How to Unpivot Data with Power Query in Excel

Показать описание

Learn how to use Power Query to quickly unpivot or normalize your data to use as the source for a pivot table. Power Query makes the unpivot process really fast and easy. It also allows you to create an automated system for updating your pivot tables, reports, charts, and dashboards.

00:00 Introduction
00:40 Insert Excel Table
03:21 Automate Process
05:15 Outro

Рекомендации по теме

Комментарии

To echo some of the other people's remarks, John, you're A DUDE and we thank you for your help with this!

kleanthisskoulikaris

You just saved me a full week's worth of manual data conversion, thank you! Wish I'd known about this in my past job where I was doing manual un-pivoting for tables with tens of thousands of

philgrupe

I'm just in awe of how amazingly clear your explanation is, thanks a ton dude

NewJayqwe

I cant emphasize how good you are. The pacing of the video and the explanation is so thorough. God bless you for sharing this

chiragdesai

This is what I was looking for. Thank u!!

ewa

Thanks so much for doing this. My boss just asked me to do this and I was totally deer in the headlights. This was so simple and easy to follow.

moniquestaple

I've been looking for this solution and you have it from 5 yrs ago. Thank you for sharing this, God bless.

yohcruz

I really want to thank you for this. This was the perfect solution to something that has had me stuck for several days. So, I learned something new today with your help that I can use in the future. Truly appreciated.

Joshuaaaaaa

This is beyond helpful. I have hundreds of spreadsheets that need to be converted. Since I just recently discovered Pivot Tables and Dashboards all the spreadsheets I created over the past 12 years can be made more readable to our employees. My daunting task was to spend hours converting the data into the correct format to utilize Pivot Tables. I'm 73 years old so time is of the essence!!!

Putttn

This is sucha great feature and your explanation is so clear - thank you!

luanwebb

Dear Guru Jon, All your Pivot table Add-in, Filter add-in and all the add-in that I got from Cut my time by It worth it, as it cut your work time so much, I do not have to be nervous cannot finish the report that I have to I will ask my client to get those add-ins. As it cut their overtime by Thank you so much Guru

TheHasbuck