Forum Discussion
Post ProdigyAltering data to tur row values in to columns
Hi, I have this data.
As you can see each file has multiple rows of same products and they can have either same or different Plant.
I can summarise it by file product and plant to reduce number of rows, but I cant fin a way to present data in a way that I want in the next step.
This is how I want data to be at the end result.
At the end result different plant would become columns and have values showing only for that plan.
Anny suggestions how I can transform my data in to this?
Hi Justas4478 ,
In Power Query, select [Plant] column.
Go to the Transform tab > Pivot Column.
In the dialog box that opens, select [Unrestricted Stock] in the 'Values Column' dropdown.
Expand the Advanced Options section and ensure that the Aggregate Value Function selected is SUM.
Pete
3 Replies
- BA_Pete
Super User
Hi Justas4478 ,
In Power Query, select [Plant] column.
Go to the Transform tab > Pivot Column.
In the dialog box that opens, select [Unrestricted Stock] in the 'Values Column' dropdown.
Expand the Advanced Options section and ensure that the Aggregate Value Function selected is SUM.
Pete
Justas4478BA_Pete I completely forgot that there is pivot option since only unpivot appears when you right click on column.
Thanks
You Can Pivot the Plant Column and in the value part of the Table.Pivot function you can have unrestricted stock Column
