Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.