Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Good morning, I hope you can help me, I want to convert columns into rows, I have data from a form, but in order not to manually extract the data, that is, count it, I need to make the headers become columns in order to better analyze the data, to be a a little clearer annex screenshots.
What is red are the headers that I want to return rows and what is blue is the data to analyze
This is what I want to obtain with this data that a table be generated in this way
This is what it would look like in Power BI
Hi @Scarthart ,
You can unpivot the columns in Power Query Editor. Here is some additional information:
https://radacad.com/pivot-and-unpivot-with-power-bi
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 68 | |
| 66 | |
| 58 |