How to change data in a request from line to column

[Arkhos94]

I have a request looking like this :

Dealer name	Function	Name
Site A	Sales director	Mr A
Site A	After sales director	Mr B
Site A	HR director	Mr C
Site B	Sales director	Mr D
Site B	After sales director	Mr E
Site B	HR director	Mr F

And I want to change it into this :

Dealer Name	Sales director	After sales director	HR director
Site A	Mr A	Mr B	Mr C
Site B	Mr D	Mr E	Mr F

I tried a few option but cannot find how to do it.

I see how to do it using "adding new column" then playing with some "if/then/else" but it doesn't look like an efficent way to do it. Is there a build-in function for this ?

[Arkhos94]

Thank you @Jakinta 

[Jakinta · Accepted solution]

Table.Pivot