Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have many columns of same table
Table A
Monthly Plan Weekly plan Actual Monthly Plan1 Weekly plan 2 Actual3
A B C D E F
I wanted them as :
Monthly Plan Weekly plan Actual
A B C
D E F
I can not create a sperate table and append it because there are so many columns and i cant create too many tables.
Solved! Go to Solution.
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