Convert columns to rows form data

Question

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

djurecic · Answer

Hi&nbsp;Scarthart&nbsp;,&nbsp;You can unpivot the columns in Power Query Editor. Here is some additional information:https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098https://radacad.com/pivot-and-unpivot-with-power-bi&nbsp;

scarthart · Answer

djurecic&nbsp;I already tried it but it does not appear the way I look for it.

Forum Discussion

Convert columns to rows form data

2 Replies

Related content

converting rows into column in powerquery

Convert Rows to columns

Converting Columns to Rows

Unique Count in Row convert

Convert Excel columns into rows in a PBI table