Excel - Merge Data from Multiple Sheets Based on Key Column

Learn how to merge data from multiple worksheets based on a matching key column in Excel without using VLOOKUP function.
#excel #data #merge #tutorial

[@mayankkumarthakur]

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.

[@janetdesenzo7502]

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!

[@Dianna369]

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!

[@khrisiamariemondragon4045]

Been working on a spreadsheet for the whole 8-hour shift and couldn’t figure anything out and I just saw this 😭 total lifesaver!!!

[@jencunnane7025]

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!

[@simonbeattie9592]

I don't normally comment on KZbin 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!!

[@MicahLouiise]

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!

[@rubiacampisoares5315]

That's gonna be my favorite video of 2020! Thanks!

[@Clairebelfort280]

This is amazing. Saved me a tone of time and it was super simple to follow, wow thanks

[@ironeez]

This was brilliant and you explained it so clearly. Thank you!

[@ghostofreality1222]

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.😀

[@sraoarjun]

So very well explained and spot on !! Thank you for the good and clear instructions

[@fj8623]

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!

[@ExcelGoogleSheets]

😀 You can actually connect directly to your SQL server in Excel, that way you wouldn't even have to import anything.

[@beckybanning1744]

Fantastic. Exactly what I wanted and an extra bonus at the end about how to merge first name and surname. Thank you so much!

[@ExcelGoogleSheets]

👍

[@sajidstar4]

Thank you, Just what I was looking for!

[@mrCetus]

This is awesome! Thank you for explaining it so clear and easy!

[@RoxxiRockstar]

You just saved me HOURS of work. Thank you so much!

[@ExcelGoogleSheets]

Glad it helped!

[@mojeff314]

Great example and walkthrough. Very helpful. Thank you.

[@nknight369]

Excellent instructional video! I am a novice and I found this easy to follow. Thank you!

[@big1cam]

You are the one! I've been putting off this massive report for months.thanks so much!!!

[@julianneyeaman6095]

Thank you for the clear instructions. Your method worked perfectly and solved a reporting problem for me.

[@karenazeez]

You just saved me! Thank you for this video, so helpful!

[@robertsalazar2788]

Thank you for the help, this was exactly what I needed and you explained every step perfectly.

[@nurulrika3075]

Thank you!! I wish I found your video before I got frustrated with many Vlookups and duplicate check, life safer!

[@sujim1870]

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.

[@ExcelGoogleSheets]

Great to hear!

[@rcm561]

You are my hero! I have bee. Looking for exactly this, and the way you taught it is perfection! Thank you!!

[@dazplay]

Brilliant! I knew there would be a way to do this I just didn't know how. Thank you so much!

[@amitkrishnani1867]

How to do this in google sheet..??

[@rhondaward13]

OMG. I cannot tell you how much you saved my life. THANK YOU!

[@margostoltz1092]

This instruction video is so helpful! You saved me hours of merging data with vlookups. THANK YOU!!!

[@psilosieni]

Oh my dear god, I love you so much. This is exactly what i've needed!!

[@romanicvs]

Absolutely excellent. I was looking for some tutorials on how to merge diverse databases in Excel, and none were really accurate. Thanks again.

[@ExcelGoogleSheets]

👍

[@mauriciogerardoramirezmend4937]

You just solved my problem in three minuts and make me save a couple of hours. Thx a lot man!

[@ExcelGoogleSheets]

Great!

[@56-ish]

Thank you very much, great simple tutorial. I've done this before just needed a refresh. Nice, quick and straight to the point

[@omonyeokoedion7325]

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

[@andreacastillo4051]

THANK YOU!!! I appreciate your help in creating this video

[@Pooh991]

Thank you so much. Your video was clear and well-explained!! I really appreciate it! It helped a lot!

[@noahobeng-nkrumah4324]

Wow, Thank you boss. This video has been so helpful. I am really grateful

[@alekhyaa9799]

You saved my day! Thank you so much. This was very helpful.

[@ExcelGoogleSheets]

Glad it helped!

[@mansurmerchant7101]

Excellent knowledge displayed...Awesome...!!!

[@kiml2328]

This is INCREDIBLEEEEE ! Thank you so much !

[@4Jibran]

Thank you so much ....Clear and specific information. Helped me learn. God Bless you Sir .

[@YogVaasishthha]

May God Bless you!! Such a nice work!

[@Valliant79]

Thanks LGS, I really appreciate this video. Awesome

[@Kafir_Hindu]

Thanks for sharing this merging technique. It helped me to get the desired set of data

[@chaitranagesh8509]

Really helped... and saved lot of my time... Very thankful.....

[@lijunshen9886]

You saved my life. Thanks!

[@jenniferallen2954]

Exactly what I needed! Thanks!

[@ExcelGoogleSheets]

Glad it helped!

[@inderjeetbhatia6380]

Thanks. Truly great. You are a life saver.

[@magoulakimou]

You saved me! Thank you!!

[@beverlysaavedra5521]

Life saver! Thank you so much for this 🙏🏼

[@ExcelGoogleSheets]

:)

[@mafukoblaise1820]

This was so incredibly helpful-thank you thank you

[@ExcelGoogleSheets]

👍

[@shabtalpur9880]

The only video which solved my problem. Thank you so much. God bless you.

[@ExcelGoogleSheets]

👍

[@HanishGuptaHoney]

Thanks. It saved my time and effort.

[@YohannesLeta]

Thank you. This is what exactly I want!

[@vivekjain9048]

Thank You for sharing this wonderful feature of excel. Saved time and effort. Much appreciated.

[@ExcelGoogleSheets]

Glad it was helpful!

[@saffetgokcensen523]

Thank you very very much for this great video.

[@user-pq9bz4eq1c]

Hero. Saviour. Thank you!!

[@malikhill1318]

Great video! Thank you!

[@tsogkhuu]

Amazed. great. helpful. liked. subscribed.

[@laurablake4759]

This is great. Thank you! Vlook up's are time consuming and confusing.

[@iramrizvi7185]

Great learning.

[@szymaniuk1983]

awesome tutorial , thanks

[@beeneealston2137]

Great job!!! I am not going to tell you how many sites and videos I followed, to no avail, before seeing this one.

[@ExcelGoogleSheets]

:)

[@EstevanDrummer]

Great, thanks a lot for this information, really useful in many daily tasks I make.

[@katestan7002]

Awesome! Thank you!

[@shashanksingh7362]

very informative, thank you soo much

[@RanaT]

This is so helpful! Thank you! :D

[@AA-fe1zl]

Thank you so much for this helpful tutorial!

[@ExcelGoogleSheets]

👍

[@kaleembabai]

Best explanation video ever

[@xlwatcher8885]

thank you! very well done

[@findthetruth3021]

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.

[@swanmute5713]

It helps me a lot, thank you very much.

[@yamax1]

Awsome ! Thank you.

[@wanjadouglas3058]

Thank you for the lesson

[@QuestzO]

U saved me mahn..thanks..I'm your new subscriber ❤

[@re-unite6828]

Excellent! thanks

[@shifanarahman34]

Really grateful for this class and explanation.

[@ExcelGoogleSheets]

:)

[@mariamaleem7917]

You are a life saver!

[@carloscortes6669]

Thank you very much!

[@manishbej7505]

Really helpful, thanks 👍

[@elenahicks2094]

Very well presented. Thanks for the helpful tips

[@ExcelGoogleSheets]

Thank You!

[@MikeVince-kl8cl]

Excellent explanation! Thank you, thank you, thank you. :-)

[@stevenchapman8114]

well explained. Thanks

[@babblecamp]

Thanks this helped me a lot

[@darthvader_]

People on YT should delete there method to merge after watching your video. This was so frustrating. Thanks a ton!

[@emmanueljacobkanagala6734]

Excellent👏

[@godfreyincmedia5862]

Excellent explanation and content

[@daylashortt4997]

I must say this was straight to the point, not of lot of unnecessary talking, because sometimes that can be distracting and HELPFULLLLLLLLLL ❤❤❤❤ thank you for creating

[@vegetasfitnesschannel446]

Awesome video helped a lot!

[@ExcelGoogleSheets]

Great!

[@nilimapriyadarshini2029]

thank you so much for this video

[@12thatguyoverthere]

You are the best!!!

[@adanhabibhussein1941]

Thank you so much.

[@AlokKumar-cl9mf]

Thank You so so so much it works for me 😊👌👌🙏🙏

[@giuliamarinangeli6353]

Thank you so much! You saved me

[@ExcelGoogleSheets]

Great to hear!

[@ejtpun1066]

THANK YOU!!!!!!!!!!!

[@everythingandanything2457]

This is very helpful!

[@ExcelGoogleSheets]

Glad it was helpful!

[@Nikocasme]

Amazing thank you so much.

[@ExcelGoogleSheets]

:)

[@krishsharma8144]

Excellent

[@anandchawda7061]

awesome...thanks!

[@vivekdoke4554]

Thank you very much! Can we automate these steps using Macros and make more interactive for better usability?

[@rahulr6374]

Life Saver!