Expanding a One to Many Delimited Column Relation

Question

Hi,&nbsp;I currently have columns like this:Column 1AColumn 2AID 1abcID 2abc,xyzID 3efg,xyzID 4abc,efg,xyz&nbsp;And I would like to end up with this:Column 1BColumn 2BID 1abcID 2abcID 2xyzID 3efgID 3xyzID 4abcID 4efgID 4xyz&nbsp;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.&nbsp;Any help would be appreciated, thanks!

elenan · Accepted Answer

Hello,&nbsp;The solution provided in this post should help you:&nbsp;https://community.powerbi.com/t5/Desktop/Split-CSV-values-in-a-column-into-multiple-rows/m-p/619520/highlight/true#M295562&nbsp;Regards,ElenaN

Forum Discussion

Expanding a One to Many Delimited Column Relation

2 Replies

Related content

Escape row delimiter within quotes

Filtercontext with date relation

decompress, skip lines, delimit

expanded table

PowerBI losing related tables in "Expand" steps

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

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