Forum Discussion

FabvE's avatar
FabvE
Helper I
1 year ago
Solved

Split rows into nested list

Hi, this might be an easy task but I'm struggeling the whole morning with this. In my table I have a column [Owners] which contains a string of emails separated by comma. I want to convert these e...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi FabvE ,

     

    Thanks for Uzi2019 and rajendraongole1 reply.

     

    FabvE Do you want to change value of Owner column to List without adding custom column? If so, you can try this.

    = Table.TransformColumns(#"Changed Type",{ "Owner" , each Text.Split(_,",") } )

     

     

     

    Best regards,

    Mengmeng Li

Uzi2019's avatar
Uzi2019
Community Champion
1 year ago

Hi FabvE 

 

Check these steps:

 

I created similar scenario , this is my data with comma seperated.

 

 

1) Go to power query

2) select your owner column

3) go to transform tab

4) split column

 

 

5) select by delimiter

6) select comma seperator then go to advance setting select row > ok

 

 

 

check the result are in seperate rows not in columns.

 

I hope i answered your question!