Expanding a One to Many Delimited Column Relation

[Anonymous]

Hi,

I currently have columns like this:

Column 1A	Column 2A
ID 1	abc
ID 2	abc,xyz
ID 3	efg,xyz
ID 4	abc,efg,xyz

And I would like to end up with this:

Column 1B	Column 2B
ID 1	abc
ID 2	abc
ID 2	xyz
ID 3	efg
ID 3	xyz
ID 4	abc
ID 4	efg
ID 4	xyz

Basically: give each delimited item it's own row and keep the relation to the ID number. I've tried unpivot and a few other things, but can't get it to work right.

Any help would be appreciated, thanks!

[ElenaN · Accepted solution]

Hello,

The solution provided in this post should help you:

https://community.powerbi.com/t5/Desktop/Split-CSV-values-in-a-column-into-multiple-rows/m-p/619520/...

Regards,

ElenaN

[Anonymous]

Excellent, thanks a bunch!