Data Transformation for Excel with two (or more) headers

Hello 🙂

You can do it easily by following below steps:

1. Get data from that Excel file and copy the query:

2. In the second query keep the top two rows only

3. Transpose the table

4. Fill down and remove empty and rename columns if needed

5. Go back to the first table and remove first row and promote header and rename needed colums and fill the year

6. Unpivot Table

7. Merge & Expand query

Hope thats answers your question.

Please don't hesitate to contact me for further support.

Best wishes 🙂

----------------------------------------------

Did I answer your question? Mark my post as a solution!