Forum Discussion
Data transformation question
Dear all, I'm not as good in power query, hence my question to you all. I have this excel data set: All "Names" are unique "Function" and "Shift" are non unique text fields Name Functio...
Hi Anonymous ,
In PQ, select your [Shift] column, go to the Transform tab > Pivot Column.
In the dialog, select [Name] as your Values Column and choose 'Don't Aggregate' from the dropdown.
Pete