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

Anonymous's avatar
Anonymous
Not applicable
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