Help - Turn one collumn with delimiter into serveral lines

[joaoantunes]

Hello,

I'm having some troubles on power bi desktop.

I have a querie with a collumn (contact_cat) that contains a lot of ids separeted by a delimiter */*, i need this collumn to be lines and not lose the info on other collums.

See here:

I want that to turn to this:

contact_cat	id	email
39	66	email1
43	66	email1
20	54	email2
46	146	email3
20	47	.
20	164	.
10	45	.
13	43	email5
20	43	email6
39	43	email7

Thanks!

[Zubair_Muhammad · Accepted solution]

Hi @joaoantunes

You can add this tustom Column and then expand it to new Rows.

See file attached as well

=List.RemoveItems(Text.Split([contact_cat],"*/*"),{null,""})

.