Forum Discussion
Rearrange Data table
Hi, I'm trying to rearrange my data table on Power Query, but i don't know how to do it. My data looks like this: And i want it to rearrange it to look like this: So, bas...
=#table(4,List.TransformMany(Table.ToColumns(PreviousStepName),each List.Skip(_,3),(x,y)=>List.FirstN(x,3)&{y}))
=#table(4,List.TransformMany(Table.ToColumns(PreviousStepName),each List.Skip(_,3),(x,y)=>List.FirstN(x,3)&{y}))
Thank you so much!