Forum Discussion
Pivot\Unpivot
I have table with a few columns, I filter to specific Order for the purpose of the example, I want to show 1 row for all orders that all type paper get his QTY . sometimes I have 3/4/5... ty...
Hi Anonymous ,
This might not be the most elegant way to achieve what you need. But have a check on this for the idea
NewStep=Table.Combine(Table.Group(YourTableInPhoto1,"Order/Line",{"n",each #table(List.RemoveLastN(Table.ColumnNames(_),2)&List.TransformMany({1..Table.RowCount(_)/2},each {"Paper","QTY"},(x,y)=>y&"_"&Number.From(x)),{List.RemoveLastN(Record.ToList(_{0}),2)&List.Combine(Table.ToRow([[Attribute],[Value]]))})})[n])
Hi, tnx.
Can you explain step by step please? I can't copy-past M code as it is.
Sorry, I want to understand the process