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.

If you've never heard of Excel's Power Query feature, you're not alone. Here's how to get started using it and gain a huge productivity boost.

Using Excel Power Query Combine Columns into Rows: Merge address data into a single column with line feed characters for better readability. Dynamic Column Renaming: Automate renaming columns ...