In this video, I will show you how to quickly unpivot data in Excel using Power Query.
Since the Pivot table needs a specific data format, in case you get the data in any other format, you need to change it to able to use it in pivot tables.
In this example, I show you a common format that you can easily unpivot in Power Query with a few clicks.
The best part about using Power Query is that it’s linked to the original data. So in case your original data expand or change, all you need to do is refresh the resulting data and it will automatically update.
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #Excelin2Minutes