Forum Discussion
How to transpose column value into header
Greeting This is my table design is as below. Order No. Material Delivery no. ABC-11 245678 400000000 ABC-11 245678 500000000 ABC-11 245678 600000000 BBC-12 112233 20000000...
NewStep=Table.Combine(Table.Group(YourTable,{"Order No.","Material"},{"n",each #table({"Order No.","Material"}&List.Transform({1..Table.RowCount(_)},each "Deliver no. "&Text.From(_)),{{[#"Order No."]{0},[Material]{0}}&[#"Deliver no."]})})[n])