Forum Discussion
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 ...
=#table({"Start","End"},List.TransformMany(Table.ToRows(Table),each List.Zip(List.Transform(_,each Text.Split(_,","))),(x,y)=>y))