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

This is the 1st 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-02 of this video series here: [ Ссылка ]
🟠 Watch Part-03 of this video series here: [ Ссылка ]

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:
[ Ссылка ]

🟠 If you are using Excel 2010 or 2013, download the Add-In from here:
[ Ссылка ]

🟠 LET'S CONNECT!

-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]

Visit [ Ссылка ] and subscribe to our blog for more content like this.

#powerquery #excel #advancedexcel #powerbi #msexcel

свернуть