God damm. I was so sick of vlookup. When I really need to do vlookup, it backfires. But this method is working for me even when vlookup is not. Thanks man. Your are a legend.
You just saved me so much time. This is so much easier than repetitive VLookups. Your video was excellent - clear and concise. I can't thank you enough!
Thanks VM for this video, it got me on the right path. After trying for almost 30 mins on the Query option, I had to move it back to the worksheet. I started messing with VLOOKUP function as you did in this video also, but then came across XLOOKUP function, that worked like a charm for what I was doing. Again big thumbs up man you got me on the right path when I was lost on this one.😀
I don't normally comment on RUclips videos, but thank you so much! I've been needing to merge a number of datasets in work and this is perfect. I was worried about having to do loads of vlookups lol!!
Excellent! I had raw SQL data stored in several different tables from a relational database that I needed to join into one table based on two specific ID columns. I'm not an SQL programmer, so didn't know how to put it together in SQL. But this video got me to my solution in Excel after importing each table as separate worksheets via CSV. Very appreciative. Good work!
omg thank you! the way you teach is impeccable, it's like you're in my mind and know exactly what I need to know and the process of how to do it!!! amazing. thanks so much!
Please how do you merge the different csv data into one file that will import all at once, because mine is just importing one data at a time instead of all
Wow, it was amazing, but that would be way better to put the files below the video as a link so that we can download it and repeat the same thing that you did. Many thanks again for this fruitful and productive video.
Do you have a video for this? I do all my estimates on an Excel spreadsheet. The cells that the address goes in is the same for all my saved estimates. I would like to collect the addresses from all my estimates and place it in one file for mailing. Can you help with this?
Do the two columns that you are merging from separate spreadsheets need to have the exact same column name if someone has named them differently in the separate files? Thanks
God damm. I was so sick of vlookup. When I really need to do vlookup, it backfires. But this method is working for me even when vlookup is not. Thanks man. Your are a legend.
You just saved me so much time. This is so much easier than repetitive VLookups. Your video was excellent - clear and concise. I can't thank you enough!
This is SUCH an improvement over 2013. Doing this sort of table merge used to be a special sort of torture.... Thank you for posting this!
Been working on a spreadsheet for the whole 8-hour shift and couldn’t figure anything out and I just saw this 😭 total lifesaver!!!
Thanks VM for this video, it got me on the right path. After trying for almost 30 mins on the Query option, I had to move it back to the worksheet. I started messing with VLOOKUP function as you did in this video also, but then came across XLOOKUP function, that worked like a charm for what I was doing. Again big thumbs up man you got me on the right path when I was lost on this one.😀
I don't normally comment on RUclips videos, but thank you so much! I've been needing to merge a number of datasets in work and this is perfect. I was worried about having to do loads of vlookups lol!!
Excellent! I had raw SQL data stored in several different tables from a relational database that I needed to join into one table based on two specific ID columns. I'm not an SQL programmer, so didn't know how to put it together in SQL. But this video got me to my solution in Excel after importing each table as separate worksheets via CSV. Very appreciative. Good work!
😀 You can actually connect directly to your SQL server in Excel, that way you wouldn't even have to import anything.
This was so incredibly helpful-thank you thank you thank you! It was exactly what I needed, and you explained it so clearly. Huge help to me!
omg thank you! the way you teach is impeccable, it's like you're in my mind and know exactly what I need to know and the process of how to do it!!! amazing. thanks so much!
That's gonna be my favorite video of 2020! Thanks!
This was brilliant and you explained it so clearly. Thank you!
This is amazing. Saved me a tone of time and it was super simple to follow, wow thanks
Thank you for the clear instructions. Your method worked perfectly and solved a reporting problem for me.
So very well explained and spot on !! Thank you for the good and clear instructions
Thank you for this video. Usually i watch more than one video to fully understand something. This time i did it in just one go. This was very helpful.
Great to hear!
Fantastic. Exactly what I wanted and an extra bonus at the end about how to merge first name and surname. Thank you so much!
👍
You just saved me HOURS of work. Thank you so much!
Glad it helped!
You are the one!
I've been putting off this massive report for months.thanks so much!!!
This instruction video is so helpful! You saved me hours of merging data with vlookups. THANK YOU!!!
Great example and walkthrough. Very helpful. Thank you.
Thank you, Just what I was looking for!
You just saved me! Thank you for this video, so helpful!
Oh my dear god, I love you so much. This is exactly what i've needed!!
Thank you for the help, this was exactly what I needed and you explained every step perfectly.
This is awesome! Thank you for explaining it so clear and easy!
OMG. I cannot tell you how much you saved my life. THANK YOU!
Thank you!! I wish I found your video before I got frustrated with many Vlookups and duplicate check, life safer!
Absolutely excellent. I was looking for some tutorials on how to merge diverse databases in Excel, and none were really accurate. Thanks again.
👍
Wow, Thank you boss. This video has been so helpful. I am really grateful
Excellent instructional video! I am a novice and I found this easy to follow. Thank you!
Thank you so much. Your video was clear and well-explained!! I really appreciate it! It helped a lot!
THANK YOU!!! I appreciate your help in creating this video
You just solved my problem in three minuts and make me save a couple of hours. Thx a lot man!
Great!
Thank you very much, great simple tutorial.
I've done this before just needed a refresh. Nice, quick and straight to the point
Please how do you merge the different csv data into one file that will import all at once, because mine is just importing one data at a time instead of all
Brilliant! I knew there would be a way to do this I just didn't know how. Thank you so much!
How to do this in google sheet..??
You are my hero! I have bee. Looking for exactly this, and the way you taught it is perfection! Thank you!!
Thank you so much ....Clear and specific information. Helped me learn. God Bless you Sir .
This is INCREDIBLEEEEE ! Thank you so much !
Really helped... and saved lot of my time... Very thankful.....
You saved my day! Thank you so much. This was very helpful.
Glad it helped!
Thanks. Truly great. You are a life saver.
May God Bless you!! Such a nice work!
Thanks for sharing this merging technique. It helped me to get the desired set of data
You saved my life. Thanks!
Thanks LGS, I really appreciate this video. Awesome
Thank you. This is what exactly I want!
Wow, it was amazing, but that would be way better to put the files below the video as a link so that we can download it and repeat the same thing that you did. Many thanks again for this fruitful and productive video.
Life saver! Thank you so much for this 🙏🏼
:)
Great, thanks a lot for this information, really useful in many daily tasks I make.
Thanks. It saved my time and effort.
This was so incredibly helpful-thank you thank you
👍
Thank You for sharing this wonderful feature of excel. Saved time and effort. Much appreciated.
Glad it was helpful!
Excellent knowledge displayed...Awesome...!!!
This is great. Thank you! Vlook up's are time consuming and confusing.
The only video which solved my problem. Thank you so much. God bless you.
👍
You saved me! Thank you!!
Exactly what I needed! Thanks!
Glad it helped!
Thank you very much! Can we automate these steps using Macros and make more interactive for better usability?
Thank you very very much for this great video.
Great job!!! I am not going to tell you how many sites and videos I followed, to no avail, before seeing this one.
:)
It helps me a lot, thank you very much.
Thank you so much for this helpful tutorial!
👍
Really grateful for this class and explanation.
:)
thank you! very well done
Great video! Thank you!
very informative, thank you soo much
Awesome! Thank you!
This is so helpful! Thank you! :D
Awsome ! Thank you.
You are a life saver!
awesome tutorial , thanks
Hero. Saviour. Thank you!!
Thank you very much!
Thank you for the lesson
Best explanation video ever
Excellent explanation! Thank you, thank you, thank you. :-)
Very well presented. Thanks for the helpful tips
Thank You!
U saved me mahn..thanks..I'm your new subscriber ❤
Thanks this helped me a lot
Really helpful, thanks 👍
Excellent! thanks
thank you so much for this video
Amazed. great. helpful. liked. subscribed.
Thank you so much.
Thank you so much! You saved me
Great to hear!
Thank You so so so much it works for me 😊👌👌🙏🙏
Great learning.
Amazing thank you so much.
:)
Do you have a video for this? I do all my estimates on an Excel spreadsheet. The cells that the address goes in is the same for all my saved estimates. I would
like to collect the addresses from all my estimates and place it in one file for mailing. Can you help with this?
well explained. Thanks
Excellent explanation and content
Great video. Could you share that file you used so we can practice ?
Excellent👏
I think that also with the Google spreadsheet this work can be done, right?
THANK YOU!!!!!!!!!!!
Awesome video helped a lot!
Great!
Do the two columns that you are merging from separate spreadsheets need to have the exact same column name if someone has named them differently in the separate files? Thanks
awesome...thanks!
This is very helpful!
Glad it was helpful!
Thank you vey much!
I have one question: can you do this with multiple Workbooks a the same time?
Yes.