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
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:
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:
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
