Use Power Query to Clean Data Already in Excel
February 22, 2023 - by Bill Jelen

Problem: My data is already in Excel. I need to transform the data. I need to unpivot the month data.

Power Query can either read from a named range or a range that has been Formatted as a Table using Ctrl+T.
Follow these steps:
1. Select one cell inside your data set.
-
2. First, convert your data set to a table using Ctrl+T.
3. Choose Power Query, From Table.
4. In the Query Editor, click on the Jan heading to select that column.
5. Shift+Click on the Dec column to select all the columns between Jan and Dec.
6. On the Transform tab, select Unpivot Columns.
7. Optionally, rename the Attribute column to be Month.
8. On the Home tab, choose Close and Load.
You will see a new worksheet with the results.

This article is an excerpt from Power Excel With MrExcel
Title photo by Nick Fewings on Unsplash