Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |