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

★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post & download the example file★

★ 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 ★

★ Where to find Excel Off The Grid ★

#MsExcel #PowerQuery

[findict]

The best I could have found for Unpivot.

[nuqwestr]

For those curious. the photo in the background is Frank Sinatra in the "spotlight" taken by Phil Stern at the JFK Inaugural Ball Rehearsal, Washington DC, 1961.”

[tdd]

Great video! Love the trick with multiple headers. Thank you!

[shiffamohammed]

Thank you so much Mark, for sharing such an amazing power query video.

[inaction]

Very clear and concise explanations. Thanks for showing us the techniques.

[nsanch]

Than you for the great video. I think I've seen ech one of those examples in real life so it was very helpful seeing you transform the with Power Query.

[daleanderson]

Great video. I know I can use the techniques you demoed. I'll just have to review the video a few more times. Thank you.

[IvanCortinas_ES]

Superb video Mark. Thank you for these complete explanation.

[gospelmoto]

Excellent! another good things is it has a sample file to practice with. Many Thanks! Got a new sub here.

[stocker.]

Très intéressant
Serais contente de suivre vos cours

[sedarathnadcd]

Thank you. It is a great help to understand complex data cleaning situations.

[arne.munther]

Instead of click on the columns header to rename Attributes to Month, you can go to m-code and make the change there.
It will give you one step less.

[ExcelWithChris]

What is the work around if you return data to a table back into Excel, but then want to do all sorts of calculations with it not being in a table? Do you copy and paste value to another sheet??? But then you will have to do it every time you update. The issue is if you return it as a table and then in the returned table add new columns with data. (for example now you add a new column for a region.