Splitting multiple values in a row to columns

=#table({"Start","End"},List.TransformMany(Table.ToRows(Table),each List.Zip(List.Transform(_,each Text.Split(_,","))),(x,y)=>y))

Hi Anonymous 

In Power Query

• Highlight the Start column
• In the Transform tab choose split by delimter and choose comma
• Highlight the columns that are created with the values
• right click and choose Unpivot columns

repeat for the End columns

thanks

Joe

Hi,

= Table.FromColumns( {Text.Split(Source[Start]{0},",") , Text.Split(Source[End]{0},",")} , Table.ColumnNames(Source))

or

= Table.FromColumns(List.Transform(Record.ToList(Source{0}), each Text.Split(_,",")), Table.ColumnNames(Source))

Stéphane