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

[@findict2570]

The best I could have found for Unpivot.

[@Omarnfm]

Amazing Idea! You are a genius.

[@stocker.76]

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

[@ExcelOffTheGrid]

J'ai un programme de formation sur exceloffthegrid.com/academy, auquel vous êtes invités à vous joindre.

[@inaction2024]

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

[@ExcelOffTheGrid]

Glad it was helpful! 😁

[@td99d]

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

[@ExcelOffTheGrid]

Thanks Trevor, I’m glad you found it useful.

[@robertowerneck6902]

Great video. Thank you!

[@ExcelOffTheGrid]

Glad you liked it!

[@nassimbahloul3081]

Très pratique, Grand Merci.

[@ExcelOffTheGrid]

De rien. 😁

[@shiffamohammed5818]

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

[@ExcelOffTheGrid]

You're welcome, I'm glad you found it useful.

[@SamehRSameh]

Marvelous 3rd method

[@ExcelOffTheGrid]

Thank you! Cheers!

[@nsanch0181]

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.

[@ExcelOffTheGrid]

Thank you. Power Query is the answer. 😀

[@ExcelWithChris]

Thanks. Greetings from South Africa.

[@ExcelOffTheGrid]

You’re welcome.

[@axeemx]

Brilliantly explained... thanks Mark.

[@ExcelOffTheGrid]

Thanks Azeem - I'm glad you found it useful.

[@gospelmoto2833]

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

[@IvanCortinas_ES]

Superb video Mark. Thank you for these complete explanation.

[@ExcelOffTheGrid]

Thanks Ivan.

[@daleanderson5258]

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.

[@ExcelOffTheGrid]

Thanks 😀 If you download the example file from the blog post you can do a bit of practice before trying it on your own data.

[@Mohamed.GadAllah]

What a master! Thanks a lot :)

[@ExcelOffTheGrid]

Thanks. Glad you liked it! 😁

[@Back1Ply]

10//10 Great Video !

[@ExcelOffTheGrid]

10/10 - i'll take that 😂

[@khalidmajeed2886]

sir you did a great job.....................iiNFLUENCER

[@ExcelOffTheGrid]

Thank you 😀

[@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.”

[@ExcelOffTheGrid]

That's really interesting. Obviously, I knew it was Frank Sinatra, but I had no idea where or when it was taken. There is just something about the lighting/shadows that I really like.

[@LaxmanBhardwaj-d2c]

Thanks

[@nitinsharma4121]

Thanks ❤

[@ExcelOffTheGrid]

You're welcome 😊

[@MrDhunpagla]

Wonderful 😊 Thanks for sharing 🤗

[@ExcelOffTheGrid]

My pleasure 😊

[@sedarathnadcd]

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

[@ExcelOffTheGrid]

Thank you, I'm glad it was helpful.

[@mohammadalbizri2013]

Highly appreciated.

[@FRANKWHITE1996]

thanks for sharing

[@ExcelOffTheGrid]

My pleasure - Thanks for watching Frank.

[@IvanCortinas_ES]

Great solution the 3rd case.

[@ExcelOffTheGrid]

Thanks Ivan, I’m glad you found it useful.

[@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.

[@ExcelOffTheGrid]

I can’t visualise the situation you are describing. Never copy and paste, it loses all the benefit gained. If you add a new column to the Table you will need to update your formulas to account for the new categorisation anyway.

[@ExcelWithChris]

@@ExcelOffTheGrid I assume it would be best to add for ex a Region / Outlet / Country column in the original data. What if you want to use Subtotals with Data Subtotals option to the new table. Will you first have to remove subtotals, refresh and run Subtotals again?

[@ExcelOffTheGrid]

@@ExcelWithChris Tables hold data in a structured format. We then use formulas or PivotTables to calculate on the Table to create the presentational format. If you try to use a Table for presentation as I think you are suggesting, you are using the wrong tool for the job.

[@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.

[@ExcelOffTheGrid]

Very true. I also would remove the auto applied steps. But I got to try and start where the viewer is likely to be.