Power BI Pivot Colums to Rows

Question

I am very new to power bi

I'm trying to pivot sub header to row. Currently I have this:

But this is not what i need

Answer 1

Hey @Nilesh, reshape the data in the Edit Queries window. Select the actual and definite columns, and choose Unpivot Columns.

Back on the Matrix, you can then use the generated Attribute field (or whatever you rename that to) as nested Rows under your Hotels field, and the generated Value field as Values.