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

Video Description

★ 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-query-unpivot-data/ ★ 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: https://twitter.com/exceloffthegrid #MsExcel #PowerQuery