Forum Discussion
Split Text by Delimiter Into a Nested List
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.
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.
2 Replies
- mahoneypatMicrosoft Employee
You can just add a custom column with = Text.Split([yourcolumn], ",")
Pat - V-lianl-msftCommunity Support
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.