Forum Discussion
Solved
How do I move column data under other columns - unpivot doesn't work here
Hi, I am trying to turn this dataset into the one below and unpivot doesn't quite seem to work. Any advice on this? Team player1.first player1.last player2.first player2.last player3.fir...
=#table({"Team","First","Last"},List.TransformMany(Table.ToRows(PreviousStepName),each List.Split(List.Skip(_),2),(x,y)=>{x{0}}&y))
=#table({"Team","First","Last"},List.TransformMany(Table.ToRows(PreviousStepName),each List.Split(List.Skip(_),2),(x,y)=>{x{0}}&y))