Excel How to Unpivot Columns using Power Query Editor

Power Query allows you to take cross-tabular data and turn it into data you can filter, sort and run subtotals. If you have data that is multi-column and the data you need must run down instead, you can use Power Query to transform this data in Excel in a couple clicks.

In this Excel tutorial, I show you how to take some multi-column data across many months and use Power Query to unpivot these columns and make them easy to sort and filter into a new worksheet.

The process should work in Excel 365, 2016, 2019, 2022, using the Get & Transform Data and Power Query so that you don't have to retype your data. I show you two methods, one by selecting the main column and unpivoting other columns, and also by selecting the unpivoted columns themselves.

Chapters
00:00 Introduction
00:22 Sample data we are using
01:13 Convert data to table
01:03 Unpivoting Columns
03:29 Loading results into worksheet
04:00 Closing remarks

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

#excel #powerquery #unpivot

[ianodonoghue]

Thank you so much. This is exactly what I need for work and will be a big time saver for me.

[vishalbhanwal]

Hi Chris Sir,
I stucked in number value to hh:mm.
But saw in your website.
Thaaankkkk yoooouuuu sooo muucchhhh sir😊😊😊

[tati]

Hey Chris, great video 🙂. I am curious, if you wanted the dates in one column and the products in separate columns with sales in the rows. How would you do that. The headers would read: Month, Hat, Shoes, Shirts and the sales for the different categories would be below.

[Shamde]

Did you ever do the follow up video where there's two header columns?

[lordtyranus]

I think you missed explaining why one method is preferred over the other or in what situations each method works best