Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey guys.
Could you help me with the following question. I get a base where I have my column records.
I need to transpose the columns and place the record under those columns.
As shown in the example below.
I need this direct solution in Power Query.
Download Pbix.
https://drive.google.com/file/d/1Snwi6gq7vRYTNsn6Bt-9sSoX__TeHoMG/view?usp=sharing
Solved! Go to Solution.
This is called 'pivoting' but you need some extra information to make it work. Add a column that groups each set of three rows. One way to do this is to add an index column from 0 and integer-divide by three so that you have this:
then you can pivot COLLUM
Result:
Spectacular, saved my weekend. Thank you very much
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |