Forum Discussion
Arkhos94
Helper IV
Helper IVHow to change data in a request from line to column
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 ?
Table.Pivot
