Learn how to easily convert data with multiple column headers to Rows using the handy UNPIVOT function in Power Query which is available in Excel and Power BI.

This is the 2nd video of the three-part video series that demonstrates how Pivot, UnPivot, and Transpose functions in Power Query can save you a huge amount of time and effort in cleaning and reshaping your data.

🟠 Watch Part-01 of this video series here:    • How to Unpivot Columns in Power Query...  
🟠 Watch Part-03 of this video series here:    • How to Pivot Rows to Columns in Power...  

Tools such as Pivot Table, Charts, Filtering, and even effective sorting in Excel need data to be structured in tabular layout. Power Query does it with ease!

I will be posting videos like this in the playlist "How to be Super Productive in Excel and Power Query", don't forget to subscribe to this channel if you have not done so.

🟠 You may download the Excel file from the blog:
https://excelfort.com/pivot-unpivot-a...

🟠 If you are using Excel 2010 or 2013, download the Add-In from here:
http://www.microsoft.com/en-us/downlo...

🟠 LET'S CONNECT!

--   / excelfort  
--   / excelfort  
--   / fowmy  

Visit https://excelfort.com/.com and subscribe to our blog for more content like this.

#powerquery #excel #advancedexcel #powerbi #msexcel