Forum Discussion
concatenate/append Columns with Different Column Names in same table
I have many columns of same table Table A Monthly Plan Weekly plan Actual Monthly Plan1 Weekly plan 2 Actual3 A B C D ...
NewStep=#table(List.FirstN(Table.ColumnNames(PreviousStepName),3),List.TransformMany(Table.ToRows(PreviousStepName),each List.Split(_,3),(x,y)=>y))
NewStep=#table(List.FirstN(Table.ColumnNames(PreviousStepName),3),List.TransformMany(Table.ToRows(PreviousStepName),each List.Split(_,3),(x,y)=>y))
Thanks ,I am not sure If I can understand this code properly,can you please explain a bit more