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
You Can Pivot the Plant Column and in the value part of the Table.Pivot function you can have unrestricted stock Column