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
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.
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!
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.
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!
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!
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.
this is awesome. I followed you steps on a real table for work and it went perfect. Only thing: what happens if I realize a column on some of my tables were missnamed? Can I change it and it updates?
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
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!!
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! 🙂
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 ?
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?
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 I learned a lot here (create connection only), helped me so much, I created a new column I need to add the table name to each entry that it come from any help on this? Thank you so much
This is awesome 😅you helped me tremendously with this information. Does the power query for the consolidated table still work if you add subtotals and totals at the bottom?
I enjoy your videos. Very clear and easy to follow. I need some help with a column. I need to fill down the customer's name into the empty cells. Nothing happens when I try the replace value with "null". I checked Data Type; it's set as "text". I'm still new to Power Query. I'm about to pull my hair out. TIA - Pam K
@ExcelCampus Thank you Jon for your great tutorials. I do have a question if you would be willing to answer. I have a sheet with a column that has a running "bank balance" style calculation =sum(I2+F3)-E3 When I refresh my data this column breaks a few cells. It actually deletes the contents of a few scattered cells but continues calculation in other cells. I have to manually drag my formula down again from just before the first broken cell. I can't find a solution online and frankly, not sure how to word the question in order to find an answer. Is there a way to prevent this column's formulas from being changed or code in the calculation in the Query Editor for this specific sheet? Thank you Jon and any of the great people in this community that is willing to answer. :)
Thanks Jon! Your video tutorial are great. I'm fairly new to Power Query and currently practicing this great tool. In your sample how would you have Power Query turn the cell in "Category" header to column? For example: Candy column, Fruit & Veg column, Beverage.... I hope you can do a video on 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.
The man, The myth, The Legend, Thank you
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
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 this helps a lot...copying and pasting was so tiring and boring
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.
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! 😀
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.
This is how you teach something. Excellent video!!! Thank you!
FINALLY!! An effective and simple way to make the Master List!! THANK YOU 😁😁 Very easy to follow.
Jon, your work is fantastic. I can't believe how much easier this makes my job. Thank you, I have learned so much!
Man, amazing... amazing teaching technique, non-arrogant communication and world class up-to-speed pace. Well done.
THANK YOU VERY MUCH JOHN FOR IMPROVING MY LEVEL IN EXCEL
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!
Please accept my Hero Award! 🏆Just Excellent!
Thank you! 😅
I truly appreciate this instructional explanation. Extremely well done! Thank you!
Glad you liked it! 😀
Very clear and quick demonstration of power query which helped me understand this tool better.
Thank you so much, using this now I can easily manage my projects
Awesome! Keep it up, Jon!
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! 😀
Thank you! I was scratching my head for too long before I found this!
Glad you found us, Triforce1006! 😀
for the algo, this was just what I needed, thx!
Awesome, thanks for watching!
perfect - got it right the first time - THANK YOU
Thank you so much, this really helped me out on an ongoing project I am completing at work!
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
I have to master this. Determined. Simplify my task of auditing my data
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!
Thanks Jon, this is awesome, just saved a few hours per year of my life
Love your teaching style! You make a difficult task so much easier. thx!
thank you very much. this is the clearest video I have watched about power query!!
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.
You rock!
I learned an awesome technique in just 12 minutes :)
Thank you so much!
Happy to help, Vinay! 😀
Thank you, this has saved me a lot of time. You've made my job a lot easier.
super easy to follow and was able to accomplish my task with your help! thank you !
You've made what I thought was impossible, possible. Thanks
Thank you very much for this video Jon. It is very helpful and insightful !!!!! 🙂
Thanks for the clear and good explanation. You're the best! Best regards, Erwin
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.
Simply outstanding teaching. Clear, concise and extremely helpful
Thanks, Ursula! 😀
Thanks helped me a lot looking forward for a macro
Awesome ,, simply Awesome . Love your teaching style - many thanks .This is a game changer for me as i manage multiple data from different source ..
Struggled with this for months thank you
Thank you. I find your explanation very clear.
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!
Very nicely describe , Easily understandable Thank you Very Much
😆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
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
Thank you so much, this was very helpful and thorough. Saved me a ton of time!
Thank you for saving my day!
Beautifully explained each step. Answered all my questions. exactly waht i was looking for. Thank you much.
Thanks for clear explanation! It's very helpful!
Thank you so much! This was very helpful and I CAN'T WAIT to apply it at my job! So useful!
This is exactly what I was looking to do! Thanks so much
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.
God bless you man ¡¡ you are our saviour
This tutorial is exceptionally helpful, perfectly explained, and well-produced -- fantastic work, thanks!
Glad it was helpful, @AutoDFensa ! 😀
Extremely helpful thanks! answered all my questions! All the other tutorials i could find were for Windows 16 which I dont have.
this is awesome. I followed you steps on a real table for work and it went perfect.
Only thing: what happens if I realize a column on some of my tables were missnamed? Can I change it and it updates?
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
Another great video! Very straightforward and easy to follow. Thanks Jon!
Thank you! Amazing teaching!
Great tutorial thanks Jon.
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!!
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! 🙂
Is it possible to have multible tables in one Sheet because its getting messy with so many sheets
Thank you. Verry nice presentation of merging sheets.
Hi Jon, awesome video man! Very useful!
Hi, John! that is awesome video, appreciated if you share the Macro to combine all tables. thank you
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 ?
Thank you, simple and easy to follow along
Thanks for the feedback, Jon! 😀
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?
It's a magic Jon !! Thank you for the video. Can you please share the video link for "connection of sheets" with the help of Macro
Thank you, very clear & to the point. I am now subscribed.
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.
Thanks a ton... this video helped me a lot!!!!
Thank you I learned a lot here (create connection only), helped me so much, I created a new column I need to add the table name to each entry that it come from any help on this? Thank you so much
Very Good Tutorial
helpful ,good examples
U r doing great job here....thanks lot...easy to understand .
Great video Jon. Maybe I missed this answer in the comments but did you had a chance to share that MACRO?
This is awesome 😅you helped me tremendously with this information. Does the power query for the consolidated table still work if you add subtotals and totals at the bottom?
I enjoy your videos. Very clear and easy to follow. I need some help with a column. I need to fill down the customer's name into the empty cells. Nothing happens when I try the replace value with "null". I checked Data Type; it's set as "text". I'm still new to Power Query. I'm about to pull my hair out. TIA - Pam K
Super useful! Thank you
Thank You!! Great video tutorial.
Very well explained. Thank you
You are a genuine
@ExcelCampus Thank you Jon for your great tutorials. I do have a question if you would be willing to answer. I have a sheet with a column that has a running "bank balance" style calculation =sum(I2+F3)-E3
When I refresh my data this column breaks a few cells. It actually deletes the contents of a few scattered cells but continues calculation in other cells. I have to manually drag my formula down again from just before the first broken cell. I can't find a solution online and frankly, not sure how to word the question in order to find an answer. Is there a way to prevent this column's formulas from being changed or code in the calculation in the Query Editor for this specific sheet?
Thank you Jon and any of the great people in this community that is willing to answer. :)
Wounderfull thanks for shared
very helpful, thx a lot
Thank you!
Thanks Jon! Your video tutorial are great. I'm fairly new to Power Query and currently practicing this great tool. In your sample how would you have Power Query turn the cell in "Category" header to column? For example: Candy column, Fruit & Veg column, Beverage.... I hope you can do a video on this. THanks.
Thank you much for this, can I still do this when I have 3million of rows combined ?
Great tutorial!
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.
Thank you very much.
Thank you so much for this video.
Wicked Tutorial!Power Query Is Simply Awesome..Thank You Jon :)
Thanks so much, Darryl! 🙌 I agree with PQ's awesomeness!