I was having so much trouble trying to do this merge and you are the only one that explained it and I got it.....no body every mentioned that the data needed to be in a table..no wonder it wouldn't work for me...YOU are the only one that included this information.
Thank you so much!!! I've consulted with so many people in my organization, and no one seems to know how to append tables using power query. Thank you!!! Bookmarked because I'll use this all the time! :D
MUCH agreed on the level of communication and explanation. After watching a few other highly recommended channels I was left with many unanswered step questions. Instructors sometimes leave out small details simply because they are so use to doing them they forget how important explaining every step is. So appreciative of how you think and share information.
Ow boy! I so love PQ! Loads!! I wish I could work only with this all day long! It makes my brain gain !! And I Loved your tutorial! I’ll stick around for more Loves Gain !! Thank you lovely! You’re such a star!
I concur with your previous subscriber. Your communication and visual materials are definitely at a high level! Thank you so much for sharing your expertise. This information helped me much!
Whilst I am generally not a fan of video instructions, this one was great! Jon really explained the concepts well, each step was easy to see and understand why it was done that way. I will be using this to help with a volunteering role and likely will look up some more of Jon's videos the next time I am trying to work out how to do something in Excel! Thank you Jon.
Great video. I took Mynda Treacy's course on Power Query so I knew the basics. This is powerful! Thanks. Really looking forward to your promised video on developing a macro to automate creating table connections in PQ.
Thanks Mark! I'm working on that video. You can download the file that contains the macro now on the blog post. www.excelcampus.com/powerquery/power-query-combine-tables/ There is a download in the section that explains the macro. I hope that helps. Thanks again and have a nice day! 🙂
Great tutorial. Very clear instructions. I only wish I had found your videos before I began working on my current project. Still, this will make moving forward so much easier.
Hi Jon thanks 🥰 for sharing your valuable informations to everyone.i really happy after watching this video. you have saved lots of hours from my daily work.god bless you Jon ❤️
Thank you for the tips this is exactly what I was looking for and I was able to catalogue my company's overstock items so we can efficiently push their sales. You da man!
Hi Jon.. great video! The more I practice Power Query, the easier it gets. Thanks for the examples and practice files.. very much appreciated :)) Thumbs up!!
Thanks Jon! I'd explored this myself, but didn't get why I had to double the sizeof the workbook by having the linked tables back in new tabs! With the tip on Create Connection Only you've got me past that hurdle! Thank you!
Thanks Rick! I'm happy to hear it. Yes, this is one of those somewhat hidden features of Power Query. It's one of those things that makes sense once you understand it, but the terminology and workflow of PQ could be improved IMO.
Hey Jon! Your communication skills are definitely on a high level. You didn't drag on or move to quickly but were able to still make your points. I do have one question. I've been googling and researching and all kinds of things to be able to pull in data from sold ebay listings to an excel spreadsheet for a price guide for my card collection. Is there any advice or help on that you could give me? Again great work
You can see if they have APIs available. They just started a new section called "My Collection" or something like that. It keeps track of your collection and current value.
Thank you so much for these videos you made available and at the reach of everyone who is willing to learn or forced to learn some tools to perform the work as required. My question is if we have different tables with different headers and we need to run a report or pivot table, how can we go with this? Thanks
I can't find any videos on how to delete a connection. My spreadsheet was not loading one of my sheets properly, so I deleted it to start over. Now my spreadsheet wont move forward because it cant find the table I deleted and it wants to know where it is. There has to be one more place that needs to be deleted, but I can't find it anywhere.
This is a very clean and smooth process in power query and demonstrated very clearly! One question--If I have mult spreadsheets saved out in a share drive folder can I still attain this combined approach into one table or do the table need to exist within one workbook?
Thank you very much, Jon; excellent delivery, clear as a bell and easy to understand. Question/comment: Each sheet has the Rep name as the sheet name, and also contains a column containing the same information. This column is redundant until the tables are combined. Would it be possible to leave that column off on all of the sheets and get Power Query to use the full sheet name (not ignoring the bit behind a space) to add a cell with that information at the end of each each row when the sheet is appended ?
Great video! Know why I'm getting an error that says "Load to worksheet failed." on the step where I Close & Load to create the additional sheet in the workbook after doing the append query for a couple tables? Note: we're talking about a hefty amount of data here (~1,400,000 rows between the two tables) and it gives me that error with yellow hazard sign and only loads 7 of the rows in the new query table sheet. Are these query table sheets subject to the same row & column limitations as a normal sheet in Excel (1,048,576 rows & 16,384 columns)?
I was having so much trouble trying to do this merge and you are the only one that explained it and I got it.....no body every mentioned that the data needed to be in a table..no wonder it wouldn't work for me...YOU are the only one that included this information.
This is the perfect kind of content. Straight to the point, clear and concise, no added nonsense. Thank you tremendously.
Thanks for the feedback Michell! 😀
Thank you so much!!! I've consulted with so many people in my organization, and no one seems to know how to append tables using power query. Thank you!!! Bookmarked because I'll use this all the time! :D
MUCH agreed on the level of communication and explanation. After watching a few other highly recommended channels I was left with many unanswered step questions. Instructors sometimes leave out small details simply because they are so use to doing them they forget how important explaining every step is. So appreciative of how you think and share information.
I don't know how to say my extremely appreciation for your video . Man, you are really next level . Thanks a million .
So nice of you, Babak! 😀
Thank you, Jon, you saved me 2 hours of tedious work per week. I'm beginning to really love Power Query.
Ow boy! I so love PQ! Loads!! I wish I could work only with this all day long! It makes my brain gain !! And I Loved your tutorial! I’ll stick around for more Loves Gain !! Thank you lovely! You’re such a star!
Thank you so much this helps a lot...copying and pasting was so tiring and boring
The man, The myth, The Legend, Thank you
Man, amazing... amazing teaching technique, non-arrogant communication and world class up-to-speed pace. Well done.
I concur with your previous subscriber. Your communication and visual materials are definitely at a high level! Thank you so much for sharing your expertise. This information helped me much!
Very clear and quick demonstration of power query which helped me understand this tool better.
Jon, your work is fantastic. I can't believe how much easier this makes my job. Thank you, I have learned so much!
Hey Jon, Thank you so much, the information was very helpful and am now able to use the power query in less than 2 minutes. good communication skills.
Thank you so much, this really helped me out on an ongoing project I am completing at work!
I truly appreciate this instructional explanation. Extremely well done! Thank you!
Glad you liked it! 😀
The most easy explanation i found, thank you so much great work and i subscribed immediately so i do not miss any of your videos in the future
FINALLY!! An effective and simple way to make the Master List!! THANK YOU 😁😁 Very easy to follow.
THANK YOU VERY MUCH JOHN FOR IMPROVING MY LEVEL IN EXCEL
Thank you, this has saved me a lot of time. You've made my job a lot easier.
You rock!
I learned an awesome technique in just 12 minutes :)
Thank you so much!
Happy to help, Vinay! 😀
thank you very much. this is the clearest video I have watched about power query!!
Whilst I am generally not a fan of video instructions, this one was great! Jon really explained the concepts well, each step was easy to see and understand why it was done that way. I will be using this to help with a volunteering role and likely will look up some more of Jon's videos the next time I am trying to work out how to do something in Excel! Thank you Jon.
Awesome, thank you Lois! 😀
Simply outstanding teaching. Clear, concise and extremely helpful
Thanks, Ursula! 😀
Love your teaching style! You make a difficult task so much easier. thx!
Thank you so much, using this now I can easily manage my projects
Awesome ,, simply Awesome . Love your teaching style - many thanks .This is a game changer for me as i manage multiple data from different source ..
I have to master this. Determined. Simplify my task of auditing my data
Thanks for the clear and good explanation. You're the best! Best regards, Erwin
This is how you teach something. Excellent video!!! Thank you!
Thanks Jon, this is awesome, just saved a few hours per year of my life
super easy to follow and was able to accomplish my task with your help! thank you !
Great tips. Looking forwards for the separate video regarding the Macro:):
Thanks for the vote Sherry! It will be out soon.
@@ExcelCampus did it come out yet? I couldn't find it! Thanks!
@@ExcelCampus
Looking forward for it aswell
Great video. I took Mynda Treacy's course on Power Query so I knew the basics. This is powerful! Thanks. Really looking forward to your promised video on developing a macro to automate creating table connections in PQ.
Thanks Mark! I'm working on that video. You can download the file that contains the macro now on the blog post. www.excelcampus.com/powerquery/power-query-combine-tables/
There is a download in the section that explains the macro.
I hope that helps. Thanks again and have a nice day! 🙂
Hi, John! that is awesome video, appreciated if you share the Macro to combine all tables. thank you
Thank you very much for this video Jon. It is very helpful and insightful !!!!! 🙂
Great tutorial. Very clear instructions. I only wish I had found your videos before I began working on my current project. Still, this will make moving forward so much easier.
This tutorial is exceptionally helpful, perfectly explained, and well-produced -- fantastic work, thanks!
Glad it was helpful, @AutoDFensa ! 😀
Hi Jon thanks 🥰 for sharing your valuable informations to everyone.i really happy after watching this video. you have saved lots of hours from my daily work.god bless you Jon ❤️
Thank you so much, this was very helpful and thorough. Saved me a ton of time!
Awesome! Keep it up, Jon!
Thank you so much! This was very helpful and I CAN'T WAIT to apply it at my job! So useful!
Extremely helpful thanks! answered all my questions! All the other tutorials i could find were for Windows 16 which I dont have.
Thank you for the tips this is exactly what I was looking for and I was able to catalogue my company's overstock items so we can efficiently push their sales. You da man!
You've made what I thought was impossible, possible. Thanks
Thank you. I find your explanation very clear.
perfect - got it right the first time - THANK YOU
Very nicely describe , Easily understandable Thank you Very Much
Beautifully explained each step. Answered all my questions. exactly waht i was looking for. Thank you much.
Hi Jon.. great video! The more I practice Power Query, the easier it gets. Thanks for the examples and practice files.. very much appreciated :)) Thumbs up!!
Hi Jon, awesome video man! Very useful!
Thanks Jon! I'd explored this myself, but didn't get why I had to double the sizeof the workbook by having the linked tables back in new tabs! With the tip on Create Connection Only you've got me past that hurdle! Thank you!
Thanks Rick! I'm happy to hear it. Yes, this is one of those somewhat hidden features of Power Query. It's one of those things that makes sense once you understand it, but the terminology and workflow of PQ could be improved IMO.
Thanks for clear explanation! It's very helpful!
Thanks helped me a lot looking forward for a macro
Thank you, very clear & to the point. I am now subscribed.
This is exactly what I was looking to do! Thanks so much
Thank you. Verry nice presentation of merging sheets.
for the algo, this was just what I needed, thx!
Awesome, thanks for watching!
Another great video! Very straightforward and easy to follow. Thanks Jon!
😆You may laugh at me, because one year ago I made a macro to do exactly the same thing! Thank you for this video!
thanks so much Jon,its great lesson God bless you
Please accept my Hero Award! 🏆Just Excellent!
Thank you! 😅
God bless you man ¡¡ you are our saviour
Thank you, simple and easy to follow along
Thanks for the feedback, Jon! 😀
Struggled with this for months thank you
U r doing great job here....thanks lot...easy to understand .
Thank you! Amazing teaching!
Great tutorial thanks Jon.
Thank you! I was scratching my head for too long before I found this!
Glad you found us, Triforce1006! 😀
Wicked Tutorial!Power Query Is Simply Awesome..Thank You Jon :)
Thanks so much, Darryl! 🙌 I agree with PQ's awesomeness!
Thank you so much.. I was searching for such a good video for hours!
You really helped me. 😀
You're welcome! 😀
Thank you for saving my day!
Very well explained. Thank you
Is it possible to have multible tables in one Sheet because its getting messy with so many sheets
Thanks a ton... this video helped me a lot!!!!
Hey Jon! Your communication skills are definitely on a high level. You didn't drag on or move to quickly but were able to still make your points. I do have one question. I've been googling and researching and all kinds of things to be able to pull in data from sold ebay listings to an excel spreadsheet for a price guide for my card collection. Is there any advice or help on that you could give me? Again great work
You can see if they have APIs available. They just started a new section called "My Collection" or something like that. It keeps track of your collection and current value.
Very useful sir tq 👍🏻👍🏻👍🏻👍🏻
Very Good Tutorial
Thank You!! Great video tutorial.
Super useful! Thank you
Thank you so much for these videos you made available and at the reach of everyone who is willing to learn or forced to learn some tools to perform the work as required. My question is if we have different tables with different headers and we need to run a report or pivot table, how can we go with this? Thanks
Excellent - great tips. Thanks Jon
I can't find any videos on how to delete a connection. My spreadsheet was not loading one of my sheets properly, so I deleted it to start over. Now my spreadsheet wont move forward because it cant find the table I deleted and it wants to know where it is. There has to be one more place that needs to be deleted, but I can't find it anywhere.
helpful ,good examples
Great tutorial!
This was an awesome video 👍👍👌
Glad you enjoyed it, @user-nm6jx9bn5k 😀
Wounderfull thanks for shared
Thank you so much for this video.
Thank you so much, the tutorial is awesome
Thanks a lot. This video makes my job quicker. then Good Job for you too!
This is a very clean and smooth process in power query and demonstrated very clearly! One question--If I have mult spreadsheets saved out in a share drive folder can I still attain this combined approach into one table or do the table need to exist within one workbook?
Such a big help :) Thank you.
very helpful, thx a lot
top tutorial. thanks!
Awesome, simple and powerful
Thank you very much, Jon; excellent delivery, clear as a bell and easy to understand.
Question/comment: Each sheet has the Rep name as the sheet name, and also contains a column containing the same information. This column is redundant until the tables are combined. Would it be possible to leave that column off on all of the sheets and get Power Query to use the full sheet name (not ignoring the bit behind a space) to add a cell with that information at the end of each each row when the sheet is appended ?
Crisp n clear, saving tons of time, knowledgeable as well
You are a genuine
Excellent
Great video! Know why I'm getting an error that says "Load to worksheet failed." on the step where I Close & Load to create the additional sheet in the workbook after doing the append query for a couple tables? Note: we're talking about a hefty amount of data here (~1,400,000 rows between the two tables) and it gives me that error with yellow hazard sign and only loads 7 of the rows in the new query table sheet. Are these query table sheets subject to the same row & column limitations as a normal sheet in Excel (1,048,576 rows & 16,384 columns)?