Power Query - Transform Data from rows to columns

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