Hi,
my question is connected with that video: https://www.youtube.com/watch?v=n72WsDKi0Yg
Apologies as this is in Polish but in final table after pivoting the persons are allocated to the relevant processes. That is the goal of this task.
What needs to be done so that in the solution, i.e. this resulting table, the names are not repeated, and where in the video in the columns describing a particular process, instead of the names duplicated from column F for example, the letter X or XX would appear ?
That is, for example, in the third row Amanda Carter (column F) is assigned to the Service Desk - cRSP process (column G) and her name is repeated there too. I would like there (column G , third row) to be a X instead of Amanda Carter's name.
The name of the file is as follows and could be accessed from a drop down list:
[ex-847 - Wartości z jednej kolumny do wielu czyli piwotowanie w Power Query] (238.6 KB)]