This was so clear and easy to understand. Can't tell you how much time this saved me. Thank you.

Just what I was looking for! So easy to understand. Thank you so much. I keep an month by month tally of my contract work but really wanted to find a way to combine it. This was perfect.

Very good. I'm going to have to watch it a couple of time though. ; )

You know that you helps thousands People one them its me !.thanks from Dubai

Teacher before i watch your lesson really u deserve a 100 like thanks a lot for help me to improve myself in our company 🌹🌹🌹🌹

Thank you so much for teaching that smoothly. Thanks to you I created a pivot table, amount of 1.7 million row and 20 column data. Made my job way easier. But if I add more data under the table we created, am I gonna get that data to pivot table that I created?

Great content! ✨🔥 Your perfect video title called my attention in my Google search. I followed all the instructions and it all worked flawlessly 🙌🏾 The part explaining the relationship was the cherry on top of the cake!!! Thanks heaps from Sydney, Australia 🦘

thanks a lot for this.. :)

I cant open the file I'm using in power query. I get an error saying Unable to Connect because the file is being used by another process. How am I to pull the sheets?

Simple and essay to understand

Very nice video I was looking to combine tables that have different columns; I mean, not the same structure. Some are the same (these I want to use for the pivot table) but there are other ones. Is is possible to combine like this?

I enjoy every single video you drop but I need help creating a questionnaire web app using excel source file

I love this!!!

It was amazing, thanks a lot ❤

Can I do this using an Excel file that's saved to SharePoint? I got stuck at importing the file into the Power Query Editor - couldn't find the file

In my use case, both worksheets are in one Excel doc, and I want to include the pivot table in the same Excel doc. When I follow the instructions for pulling the source in Power Query, I get an error that the document is being used by another process. In the video, it looks like you're working in the same Excel doc. Thoughts?

thank you

My only question is when I do data>get data > excel (new /recent) I am getting the power query on a new file. Cant I have it on the same file with my data ? what am I doing wrong ?

i am not getting pivot table report option under close & load tab