3 Methods to unpivot in Excel using Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy



★ Check out the blog post & download the example file★
https://exceloffthegrid.com/power-que...


★ About this video ★
I used to be amazed at people who could use complex formulas. I picked up lots of tips and tricks by learning these advanced techniques. But I soon discovered that getting data in the correct format at the start meant I didn’t need those advanced formula skills. Because once the data is in the proper structure, Excel becomes easy!


0:00 Introduction
1:05 Basic unpivot in Power Query - Method 1
3:42 Unpivot with multiple columns - Method 2
6:31 Unpivot with multiple header rows - Method 3
11:00 Conclusion


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/



★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com

Twitter:   / exceloffthegrid  


#MsExcel #PowerQuery