Altering data to tur row values in to columns

[Justas4478]

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?

[aTa_Shaikh]

You Can Pivot the Plant Column and in the value part of the Table.Pivot function you can have unrestricted stock Column

[BA_Pete · Accepted solution]

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

[Justas4478]

@BA_Pete I completely forgot that there is pivot option since only unpivot appears when you right click on column.
Thanks