Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/unpivot-advanced-file

[@excelisfun]

Power Query: the greatest tool since the PivotTable! Thanks, teammate : )

[@LeilaGharani]

Couldn't agree more, teammate!

[@husseinmahmoud5210]

I learnt much from you both during the last 4 years, do really appreciate your overwhelming touch in my caree, owe you much

[@irbo84]

You guys rock and i watch you both all the timee!!!

[@davidjames9769]

OK, I give up ; totally confused. My screen doesn''t look like your screen

[@lilanthawijerathne3085]

Learn lot from both of you . Salute !!

[@duffygc]

I've watched hundreds of Excel videos over the years, and this is probably the best I've ever seen; the perfect balance of context, explanation, insight and detail (and exactly what I needed help with today). Thank you, Leila.

[@LeilaGharani]

Wow, thanks Greg! Glad it was helpful.

[@not1AM]

maaaan... I could not ever imagine myself 15 years ago spending my leisure time exploring the all mighty EXCEL .. thanx for your amazing videos

[@chrislynch6545]

Thanks! This was so easy and elegant and I imagine the tricks you used will come in handy in unexpected ways in the future. You rock!

[@dannykurniawan3480]

Thank you SO MUCH, Leila 🙏 This tutorial has saved me from manually unpivoting Multinational Sales Data of 14 products with 3 levels of headers (Countries, Ports, Months).

[@LeilaGharani]

Glad it was helpful!

[@ajit555db]

I had totally different Financial Ledger data in multiple row headers. Was breaking my head to manually change to tabular format, then came across your video. Followed your steps and yo!!...structured it beautifully in a simple tabular format. Thank you so much for so clear and concise instructions.

[@nadeemmalik8031]

Time spent with Leila learning new ways and techniques in excel is time well spent. Thank you Leila.

[@LeilaGharani]

Glad you think so!

[@Jollofloff]

Thank you! Spent the entire day untangling a large table. This video made the same thing possible in 15 minutes!

[@AlexanderKonig2577]

ooooooooo... this was a nightmare for so many years!! hours and hour unpivoting survey data!! thank you so much!! great work!

[@LeilaGharani]

Hope it will come in handy for you Alexander.

[@JuanLuisZamora]

This is such a High Quality Tutorial, including the workbook, it is very satisfying to see how much love and effort you and your team put in doing this, some day it'll pay off.

[@LeilaGharani]

Wow, thank you!

[@chh8860]

Thursdays mornings with Leila is 'must-attend' classroom time … and this morning was another excellent presentation (no surprise) in terms of delivery and content … and a very timely topic for me. Thank you Professor Leila … PS A 'Pro' makes things look easy … and Leila is an 'All-Star' Pro … the Star of the 'Show' … she is my hero (heroine???) as I toil away in the minor leagues trying to get a little better each day … all her videos provide excellent training techniques … thank you … thank you … thank you.

[@LeilaGharani]

😘

[@brbball]

Amazing, and, ohhhh, I would have loved this 20 (ok, 35) years ago. I used this tonight to help a PhD candidate better organize her qualitative data. (I also used a similar technique she describes in another video.) Thank you, Leila!

[@garys2187]

I ended getting your Power Query course as a result of your videos on Power Query. I am so glad I did!!

[@LeilaGharani]

Wonderful! Glad you liked it, Gary!

[@jah3148]

Honestly PQ blows my mind more every day. I had a report with multiple headers I naively believed I just couldn’t work with without changing the source table. With this I was able to quickly unpivot like a pro.

[@LeilaGharani]

It really is a miracle tool 😊

[@SkysUp-yo2gc]

Great content! Thank you Leila for such a clear-cut video! Saved me A LOOOOT of time and multiple headaches. Big addition to my data cleaning know-hows

[@jessicasnyder4358]

I've spent DAYs googling for this solution - excellent video! THANK YOU!

[@therevenant211]

This video saved me HOURS of effort and got me tons of kudos at work - thank you for taking the time to put together these videos that are both reasonably short and eminently practical! Knowing excel has been a major game-changer for my career and it's content creators like you and Mynda Treacy who have gotten me to where I am. Thank you!

[@LeilaGharani]

Wow, that's so great to hear! Thank you for the kind feedback!

[@jamesfrelichowski6990]

After two days of googling for tips you gave me exactly what i needed! And I love your style of presentation the best. I needed to sum up data for each cultivar of plant across all the days of the year. This makes it easy to make rows of each data point because of all the blanks for most plants on most days and because further analysis do better without blanks taking up space and memory. Eventually i want to move it to an access table and it is setup this way and keep the informative columns to the left of the actual data. Other databases like GRIN-Global are this way also but original data gathering is still best with excel condensed worksheets. THANK YOU SO MUCH! I will look to subscribe.

[@henrikmanukyan3152]

I can't believe all these treasures were here in KZbin and I didn't notice !!! Good that i found 😀 highly recommend to anyone who wants to advance in data analysis 😉

[@geoffreydeleplanque7690]

Leila you are insane, I followed many excel Chanel but yours is the most clear and simple to follow, I improved a lot myself with you. Thanks

[@HighHopesHizzy88]

Leila, Thank you for posting these awesome videos. Your impressive teaching style is so easy to follow. I love Excel, but I'm mostly self taught, which can make it difficult to understand the lingo, etc., in certain tutorials as I troubleshoot. Your videos are so clear that I find myself watching them just for fun. Thank you for rekindling my love for Excel. Be well!

[@LeilaGharani]

Thank you! I'm glad you like the videos.

[@markmanyau6463]

data management made simple. Power querry is a game changer. Leila you are a star

[@RobHOUTX46285]

I was wondering how this could be done. I'm glad I googled instead of trying it myself. Your idea is brilliant and works and I wouldn't have come up with the sequence of steps myself!!!!

[@LeilaGharani]

Glad I could help, Robert!

[@fluffybasket5674]

Thank you for always coming in clutch ahead of my deadlines lol We love an Excel Queen!

[@gregorytaylor2749]

I am halfway through your course and it has paid for itself in one day in time savings!

[@anilbabbar2290]

Amazing, thank you. I have been struggling with Multiple Headers, it has given me a breath of fresh air. Thank you again.

[@yongqingyang2815]

This is the best video on this topic that I watched. Thank you so much for your sharing!

[@LeilaGharani]

Wow, thank you!

[@Gordi_B]

Thanks!

[@LeilaGharani]

Thank you!

[@maiguelguti6818]

Wow! I used to merge into 12 columns and then unpivot, this method is way more efficient and easy. Thanks for sharing!!

[@LeilaGharani]

Glad it was helpful!

[@westielvr1]

THANK YOU! This video saved my sanity! I am fairly new to Power Query and this was extremely easy to follow and understand!

[@davebalberona4650]

Thank you so much. This is what I've looking for. I'm working for more than 10k rows of data that has been generated from analysis. My work is to unpivot the data so that it can be use for pivoting. Good thing I bump into your video and I completed the task. PS. I don't have any knowledge of power query just a basic excel knowledge

[@sivaprasad1717]

Thank you Leila, this video is the end for my whole day struggle.

[@zahratorabi7638]

Oh my god, my problem since years is solved 🤓 Leila, another time a great solution. You are my angle! Thank you sooo muuuch. God bless you. 🌻🌻🙏🙏🙏

[@LeilaGharani]

You're welcome 😊

[@ZanetaNoreikaite]

This is amazing! From presentation skills to content!! Thank you!

[@oxymoira]

i just downloaded ur excel reference table with ur videos which allows me to search better than on utube - tyvm ! :)

[@LeilaGharani]

Awesome, thank you!

[@dariaresch]

Dear Leila, thanks a lot for your video. I would still have a question on how to keep Actual and Budget in separate columns. Could you please help? thanks

[@ezekiel0606]

As always, you have the perfect video to a niche question. Thank you!

[@roderickmose4691]

I never could find a use for remove table headers... until today. All around great insight, Leila!

[@LeilaGharani]

You're welcome!

[@felipe4181]

Excellent explanation Leila thank you!!!! I wouldn't had eliminated the "null" at the end, I would've replaced them with "0" and keep the data in order to show changes on sales of the articles upon the time!

[@Oppadu]

You are the best, Always! Thank you for uploading great video ❤️

[@MrNusoh]

Hi 오빠두, I am your big fan:):)

[@AlexVideoProductions]

Very amazing and instructional video tutorial, it helped me to solve one problem I had. Thank you so much.

[@Archie167]

This video was released on my Birthday :) Watched it today and it worked.

[@mujuw]

This is such a useful video, thank you so much! I'll be sure to explore your courses :)

[@nqaiser]

Clear, concise, High Quality material. Thank you for this

[@wsmkhan]

This is brilliant!!! Not sure, how can anyone dislike this video? May be they didn't know about Excel ;)

[@srinivasulur8938]

You are simply super! I really appreciate your efforts in sharing the knowledge to all!

[@vivekananthradhakrishnan2339]

You are such a good trainer.. I hope you are patient in real life too like this. I will even learn algebra in klingon

[@ThatOfficeGuy]

It still surprises me that not many people are aware of Power Query. It’s a great function and once you learn how it works you can really optimise your work.

[@LeilaGharani]

So true!

[@Isrosman]

Your videos are the best I ever watched !!! Thank you for sharing your knowledge :)

[@LeilaGharani]

Wow, thank you!

[@mohammedlabeeb]

OMG. I love all your videos. IDK what job that will let me work in excel and do cool stuff like this.

[@christophertauss3640]

Outstanding video. I use Power Query a lot, but this use case of multi headers has been a stumbling block. This video has a lot of great ides how we can use work with this. The more I learn about power Query, the more I am amazed at what it can do. Thanks for sharing this and I have subscribed and look forward to other great videos you may have.

[@LeilaGharani]

Thanks for the sub, Christopher!

[@jyothinarendra993]

The course is so intresting and its very easy with examples workouts. I give five ⭐ for this course. Thanks for sharing knowledge.

[@LeilaGharani]

Wow, thank! That's great to hear.

[@followyouaround]

amazing!!!! you are so amazing. you just saved like hours of stupid things i could've tried to clean up my data with multiple attributes. thanks so much!

[@zachmetrology6342]

This was an absolute godsend! Thank you!

[@rishabhkesharwani7761]

Again learn a excel magic trick with great "Magician" "Leila Ma'am" 🤠🇮🇳

[@harshalpatil2111]

Really shs a Magician. Big thumbs-up

[@luchinvisagie1452]

Love you , your videos are making me a rock star at our company

[@LeilaGharani]

Rock on!😁

[@asankadilshansenarath910]

Thanks a lot for the video.This saved my 2 days of work.

[@seshakv]

This power query i say is madness redefined. simply brilliant. Thank you so much for the video.

[@LeilaGharani]

You're very welcome.

[@Aussified]

Saved my life today. Couldn't thank you enough!

[@miguelangelponce8553]

Great explanation and example, thak's a lot Leila (Greetins from México)

[@SimohmedRaiss]

So wonderful. Thank you so much Leila. I used to do lots of copy/paste, with a high risk of errors, to get this result. I do as well, appreciate a lot the trick of the Split button. Very useful. 👍👍

[@huguititi]

GOD!!! You help me a LOT!!! with this video... many many thanks

[@rinkiko]

Thank you for creating these videos they are super helpful

[@emmafeng55]

Thank you very much Leila! This is definitely a life saving function!

[@gesalerico]

Wonderful, I know more on excel thanks to the great Leila!

[@LeilaGharani]

Great to hear!

[@ssegall1984]

Wonderful walk through. So many of these just stop at the simplest option

[@samuelolarte1328]

I wish I could hit that like-button more than once. Thanks a lot for sharing your knowledge!! 🙌🏽🙌🏽

[@LeilaGharani]

So nice of you, Samuel :)

[@tademustapha4954]

Brilliant video. Every action beautifully explained. Thank you Leila

[@puneethkumar8131]

Thank you. This saved a lot of work for me.

[@husseinmahmoud5210]

Amazing Leila, these complex situations really needed to learn about

[@jimfitch]

Great technique! Thanks, Leila. I have not encountered this situation, but I’m sure I will. Now, I’ll be ready!

[@LeilaGharani]

Always good to be prepared :)

[@abdallah.kandiel]

Happy Thursday your highness The nested headers was a challenge to me . And still . I will watch and brb Thanks in advance

[@LeilaGharani]

Hope the video can help :)

[@abdallah.kandiel]

@@LeilaGharani It was really helpful But for me it needs some practice to gain it . But as always you are shinning.thanks a million leila

[@kuldeepsinghbhati1629]

when i transpose table my excel giving me errors about memory (Expression.Error: Evaluation ran out of memory and can't continue.) why?

Thank you @Leila. When I unpivot my table null values disappear while I'd like to keep them as the null is bearing an information. How to prevent them from disappearing please?

[@katerynakulich905]

Thank you a lot for the tutorial! You help me to solve the task

[@maureenolesen9612]

This blew my mind. Thank you!!

[@evelic]

Brilliant, just what I needed. Thanks.

[@ahamadaibrahimben8596]

It's awesome what we could learn with you Leila Thanks a lot

[@IvanCortinas_ES]

Excellent tutorial Leila. Thank you very much for your time and effort!

[@LeilaGharani]

My pleasure, Iván! Glad you like it.

[@SpiritualMotto]

It gives me my feed of the day about the Power query and appreciate your detailed explanation. I encourage you to upload more videos

[@aniljaggarwal60]

you have amazing knowledge of excel 🎉

[@priyankshah4786]

You are MS Excel wizard 👍👍

[@LeilaGharani]

Wow, thanks

[@karldc83]

At 12:21 If you remove 'null', then add new data, will the new data values show up if if wasn't in the original data as the filter or new values also be excluded? When I filter 0's I always do 'does not equal' 0 instead of unchecking 0 for that risk. Thank you for the video!

[@varsharampuria7730]

Hi, This video is amaazzzingg!! Solved my long drawn problem quickly!! Thank you! Bless you!

[@h47r14n1]

I have a question, when we unchecked null value at the final step to clean our data, does it mean that we checked every single existing value except null? which means if there is a new value added into data sources (ex : add May or June data) it will be not checked

[@katiefarrand7742]

Thank you so much, exactly what I was looking for!

[@rotethongvanit]

Not an easy one. But power query is a great tool for the business world. Thanks.

[@peterdallyn6440]

Great insight I didn't realise that you could do that. I'm going to have to spend some time learning unpivot, another really useful video.

[@carlossasis5349]

This is very informative!! The learning is life changing!! 🥰🥰

[@LeilaGharani]

I'm glad it's helpful, Carlos!

[@AlvaroPerez-ox7ul]

You ended a strong headache, Thank you so much.

[@LeilaGharani]

My pleasure, Alvaro.

[@AlvaroPerez-ox7ul]

@@LeilaGharani Thanks for getting back! Always been a fan! I don't want to bother you since you make so much and amazing content, but if you could give some tips on the Transpose step, if you have numeric and text data under the same merged header, $us and Kg for instance. Thank you!

[@andronecesito4216]

Very helpful and informative!

[@arwaabougharib8698]

Thank you! You're a life-saver!

[@wayneedmondson1065]

Hi Leila.. great video and transformation. I'm in your course (love it) but have not yet reached this lesson. Thanks for the preview and the great tips and tricks shown in the video. Thumbs up!!

[@oklims]

good morning Leila, did you notice that if you remove column header like in minute 4:35, power query go in error when updating, cause PQ no more find "Column1" ?

[@serigamel]

Thanks Leila. This was helpful

[@LeilaGharani]

Happy to help.

[@nataliakarolczuk5474]

Oh Leila, thanks to your KZbin tutorials, I am becoming more and more confident with my excel skills! Wonder if you could help me a bit more. I have 2 and 3 rows headers and data below it following in the same order. I would like to split that into columns with relevant data, and I am just lost how I can do that...🙏🆘️😊

[@dandiamants5078]

thanks a lot Ms Leila it is such a help watching your VLOG

[@iawwad]

I'm just wondering where this power query is going, it's really becoming like a magic wand, you are the wizard :) Thanks, Leila.

[@LeilaGharani]

It really is like magic :)

[@nagenderswaroop5227]

Thanks Madam alot it was really helpful to me