Convert columns to rows form data

[Scarthart]

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]

Hi @Scarthart ,

 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-f5882...

https://radacad.com/pivot-and-unpivot-with-power-bi

[Scarthart]

@djurecic I already tried it but it does not appear the way I look for it.