Calculated table with columns based on the values from another table

[LakiCG]

Hi,

Does anyone know how I can transform next table which is data source to the second table shown below.

This is my data source. As you can see, there are multiple rows referring to the sam transaction.

TransactionID	Name	Role	Locations
001	John Smith	Sales Person	New York
001	David Johnson	Manager	New York
001	Alex Berman	Buyer	New York
002	Mike Tomphson	Sales Person	Boston
002	Dan Jordan	Manager	Boston
002	Marko Black	Buyer	Boston

I would like to transform this sourcing table in Power BI to the table below (based on the people's role from the first table, I want to create the new columns, so each transaction is shown just in one row). This is what I want to see in Power BI:

TransactionID	Sales Person	Manager	Buyer	Locations
001	John Smith	David Johnson	Alex Berman	New York
002	Mike Tomphson	Dan Jordan	Marko Black	Boston

Please does anyone has an idea how to achieve this?

Many thanks!

Laki

[dramus · Accepted solution]

Pivot the Roles column.

i

[LakiCG]

It works. Thank you!