Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

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.

Learn how Power Query can boost your Excel skills with tips to clean, transform, and analyze data faster and more efficiently.