Pivot\Unpivot

[Avichai_ka]

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... types paper 

I try this : 

[mussaenda · Accepted solution]

Hi @Avichai_ka ,

This might not be the most elegant way to achieve what you need. But have a check on this for the idea

[Avichai_ka]

wow!!!
This is working, I try now to remove "WHERE" for to be dinamic

[wdx223_Daniel]

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])

[Avichai_ka]

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

[Avichai_ka]

Hi , 
I want to display for every order 1 row .
From source table (photo 1) I want to get :

Thank you

[christinepayton]

It looks like you are unpivoting and then re-pivoting - usually you would only do one of the two at a time, what are you trying to accomplish exactly?

[AbhinavJoshi]

Hi @Avichai_ka . To understand your question better, you would like the paper types as the row? Or can you share one sample output you are expecting. Thanks