Now that the data from the workbooks has been combined and transformed, it's time to see how it looks in a regular Excel worksheet. In the Home tab on the Power Query Editor window, click the top half ...

Then, in the Power Query Editor, select the headers of all the columns you want to unpivot. In this example, you'll need to click the "2020" header, press Shift, and then click the "2024" header.

In the Power Query editor, identify the column or column that contains the values you want to use for the subheadings. 2. Create a new column in the Power Query editor to store the subheading values.