Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Splitting multiple values in a row to columns

Hi Team,   I have one scenario Which is having two columns Start and End.   Start        End A,B,C        X,Y,Z     and I need output like this.   Start       End A              X B      ...
Need Help
slorin's avatar
slorin
Super User
3 years ago

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