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.