Forum Discussion
Split rows into nested list
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
Hi FabvE - Certainly! It sounds like you want each cell in the [Owners] column to contain a list of emails (instead of a single comma-separated string)
Select the column [Owners] and go to the Add Column tab.
Choose Custom Column, and in the dialog box that appears, use the following M code
= Text.Split([Owners], ",")
Sometimes emails separated by commas have extra spaces, which can interfere with your list format.
= List.Transform(Text.Split([Owners], ","), each Text.Trim(_))
Once done, select Close & Apply to load your transformed data back into Power BI.
Hope this works.
HI,
thank you but this creates another column. Is there a way to transform the original column without creating an additional one?
I want to avoid unnecessary steps in my query. 🙂
