Split Text by Delimiter Into a Nested List

[IHarg]

Hello,

I have a column whose rows each have two pieces of content in a text format as seen below: 

I want to take this content per column and create a column whose cells contain a list:

The purpose of this is there an unknown number of elements needed in each row, so, instead of delimiting into several new columns, I can just have a single column contain a list of elements needed for that row. I will later have to convert the list into a table so I can merge with the DIM table containing the keys related to each element as well. Let me know if there is a better way to approach this problem or if further information is needed. Thanks,

Isaac.

[V-lianl-msft · Accepted solution]

Hi @IHarg ,

Please try split into rows:

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

You can just add a custom column with = Text.Split([yourcolumn], ",")

Pat