Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to Solution.
Table.Pivot