Power Query - Transform Data from rows to columns

[-TP-]

Hi, seeking for some help.

I have a database with thousands of items and their sell prices from many competitors in different locations (similar to the below table).

I was wondering how to trasnform it in power query to have a single line for each item and the competitor prices on columns (similar to the below).

It is easy to do with a Pivot Table, but I do not know how to do it in Power Query.

Thanks in advance!

TP

[wdx223_Daniel · Accepted solution]

Power Query also have a pivot function

=Table.Pivot(YourPreviousStepName,List.Distinct(YourPreviousStepName[Competitor]),"Competitor","Price")