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.

The Power Query Editor allows you to select multiple columns in the order you want to place them and then drag the columns together to their desired location.

Learn how to streamline Excel tasks with Power Query and VBA, unlocking smarter workflows and advanced automation techniques. MS Excel 2025 ...