CROSS JOIN two column ... row by row

[derumiya]

subject title is mis-leading but here is what I would like to achieve

I have table like this;

would like to convert to;

any idea?

thanks

[PhilipTreacy · Accepted solution]

Hi @derumiya 

Download example PBIX file

Split the column by Delimiter, a comma,

and split into rows for each occurrence of a comma

Result

regards

Phil

[derumiya]

great!  thank you so much