Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
i wish to pivot my excel data so that it will look like the bottom one.
How can i achive this?
Thanks!
Solved! Go to Solution.
Hi,
In Query Editor.
1. Select the column with the Budget / Actual
Transform - Unpivot Other Columns
2. Select the column with Budget / Actual
Pivot Column: Value
Regards
Victor
Hi,
In Query Editor.
1. Select the column with the Budget / Actual
Transform - Unpivot Other Columns
2. Select the column with Budget / Actual
Pivot Column: Value
Regards
Victor
Thanks for your help!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |