Forum Discussion

IHarg's avatar
IHarg
New Member
4 years ago
Solved

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

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

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


    Pat

     

  • V-lianl-msft's avatar
    V-lianl-msft
    Community 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.