Forum Discussion
Justas4478
Post Prodigy
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 numb...
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
BA_Pete
Super User
Super UserHi 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