Excel - Merge Data from Multiple Sheets Based on Key Column

Sdílet
Vložit
  • čas přidán 19. 05. 2019
  • Learn how to merge data from multiple worksheets based on a matching key column in Excel without using VLOOKUP function.
    #excel #data #merge #tutorial

Komentáře • 251

  • @janetdesenzo7502
    @janetdesenzo7502 Před rokem +11

    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
    @Dianna369 Před 5 měsíci

    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!

  • @mayankkumarthakur
    @mayankkumarthakur Před 2 lety +13

    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.

  • @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!!!

  • @MicahLouiise
    @MicahLouiise Před 4 lety +1

    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
    @rubiacampisoares5315 Před 3 lety +8

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

  • @simonbeattie9592
    @simonbeattie9592 Před 3 lety +4

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

  • @ghostofreality1222
    @ghostofreality1222 Před 2 lety +2

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

  • @jencunnane7025
    @jencunnane7025 Před 2 lety +13

    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!

  • @fj8623
    @fj8623 Před rokem +6

    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
      @ExcelGoogleSheets  Před rokem +4

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

  • @RoxxiRockstar
    @RoxxiRockstar Před 4 lety +5

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

  • @ironeez
    @ironeez Před 3 lety +4

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

  • @Clairebelfort280
    @Clairebelfort280 Před 3 lety +4

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

  • @big1cam
    @big1cam Před rokem

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

  • @julianneyeaman6095
    @julianneyeaman6095 Před 4 lety

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

  • @margostoltz1092
    @margostoltz1092 Před 10 měsíci

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

  • @sraoarjun
    @sraoarjun Před 4 lety +1

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

  • @sujim1870
    @sujim1870 Před 4 lety +1

    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.

  • @rhondaward13
    @rhondaward13 Před 5 měsíci

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

  • @beckybanning1744
    @beckybanning1744 Před rokem +1

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

  • @mojeff314
    @mojeff314 Před 3 lety +1

    Great example and walkthrough. Very helpful. Thank you.

  • @sajidstar4
    @sajidstar4 Před 3 lety +3

    Thank you, Just what I was looking for!

  • @mrCetus
    @mrCetus Před 2 lety

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

  • @mauriciogerardoramirezmend4937

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

  • @nknight369
    @nknight369 Před 25 dny

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

  • @psilosieni
    @psilosieni Před 3 lety +5

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

  • @rcm561
    @rcm561 Před měsícem

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

  • @karenazeez
    @karenazeez Před 4 lety +1

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

  • @nurulrika3075
    @nurulrika3075 Před 3 lety +1

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

  • @robertsalazar2788
    @robertsalazar2788 Před 3 lety

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

  • @56-ish
    @56-ish Před rokem

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

    • @omonyeokoedion7325
      @omonyeokoedion7325 Před rokem

      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

  • @dazplay
    @dazplay Před 3 lety +3

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

  • @andreacastillo4051
    @andreacastillo4051 Před 3 lety

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

  • @Pooh991
    @Pooh991 Před rokem

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

  • @romanicvs
    @romanicvs Před rokem +1

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

  • @lijunshen9886
    @lijunshen9886 Před 3 lety

    You saved my life. Thanks!

  • @4Jibran
    @4Jibran Před 2 lety

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

  • @Valliant79
    @Valliant79 Před 2 lety

    Thanks LGS, I really appreciate this video. Awesome

  • @noahobeng-nkrumah4324
    @noahobeng-nkrumah4324 Před 4 lety

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

  • @kiml2328
    @kiml2328 Před 2 lety

    This is INCREDIBLEEEEE ! Thank you so much !

  • @chaitranagesh8509
    @chaitranagesh8509 Před 4 lety +1

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

  • @YogVaasishthha
    @YogVaasishthha Před 9 měsíci

    May God Bless you!! Such a nice work!

  • @user-pq9bz4eq1c
    @user-pq9bz4eq1c Před 3 měsíci

    Hero. Saviour. Thank you!!

  • @shabtalpur9880
    @shabtalpur9880 Před 2 lety

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

  • @mansurmerchant7101
    @mansurmerchant7101 Před 3 lety +1

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

  • @inderjeetbhatia6380
    @inderjeetbhatia6380 Před 3 lety

    Thanks. Truly great. You are a life saver.

  • @magoulakimou
    @magoulakimou Před 4 lety +1

    You saved me! Thank you!!

  • @Kafir_Hindu
    @Kafir_Hindu Před 5 měsíci

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

  • @YohannesLeta
    @YohannesLeta Před 2 lety

    Thank you. This is what exactly I want!

  • @alekhyaa9799
    @alekhyaa9799 Před 4 lety

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

  • @mariamaleem7917
    @mariamaleem7917 Před 6 měsíci

    You are a life saver!

  • @jenniferallen2954
    @jenniferallen2954 Před 4 lety

    Exactly what I needed! Thanks!

  • @HanishGuptaHoney
    @HanishGuptaHoney Před 3 lety +1

    Thanks. It saved my time and effort.

  • @vivekjain9048
    @vivekjain9048 Před 3 lety

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

  • @katestan7002
    @katestan7002 Před rokem

    Awesome! Thank you!

  • @malikhill1318
    @malikhill1318 Před 3 lety

    Great video! Thank you!

  • @laurablake4759
    @laurablake4759 Před 4 lety +1

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

  • @saffetgokcensen523
    @saffetgokcensen523 Před 8 měsíci

    Thank you very very much for this great video.

  • @beverlysaavedra5521
    @beverlysaavedra5521 Před 2 lety

    Life saver! Thank you so much for this 🙏🏼

  • @findthetruth3021
    @findthetruth3021 Před 5 lety

    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.

  • @mafukoblaise1820
    @mafukoblaise1820 Před rokem

    This was so incredibly helpful-thank you thank you

  • @wanjadouglas3058
    @wanjadouglas3058 Před 4 měsíci

    Thank you for the lesson

  • @swanmute5713
    @swanmute5713 Před rokem

    It helps me a lot, thank you very much.

  • @re-unite6828
    @re-unite6828 Před 2 lety +1

    Excellent! thanks

  • @EstevanDrummer
    @EstevanDrummer Před 2 lety

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

  • @RanaT
    @RanaT Před 11 měsíci

    This is so helpful! Thank you! :D

  • @shashanksingh7362
    @shashanksingh7362 Před 3 lety +1

    very informative, thank you soo much

  • @manishbej7505
    @manishbej7505 Před 5 měsíci

    Really helpful, thanks 👍

  • @beeneealston2137
    @beeneealston2137 Před 2 lety

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

  • @xlwatcher8885
    @xlwatcher8885 Před 4 lety

    thank you! very well done

  • @shifanarahman34
    @shifanarahman34 Před 2 lety

    Really grateful for this class and explanation.

  • @carloscortes6669
    @carloscortes6669 Před 3 lety +1

    Thank you very much!

  • @kaleembabai
    @kaleembabai Před 20 dny

    Best explanation video ever

  • @szymaniuk1983
    @szymaniuk1983 Před 4 lety

    awesome tutorial , thanks

  • @yamax1
    @yamax1 Před 3 lety +1

    Awsome ! Thank you.

  • @12thatguyoverthere
    @12thatguyoverthere Před 12 dny

    You are the best!!!

  • @AA-fe1zl
    @AA-fe1zl Před rokem

    Thank you so much for this helpful tutorial!

  • @iramrizvi7185
    @iramrizvi7185 Před 3 lety +1

    Great learning.

  • @tsogkhuu
    @tsogkhuu Před 2 lety +1

    Amazed. great. helpful. liked. subscribed.

  • @stevenchapman8114
    @stevenchapman8114 Před 8 měsíci

    well explained. Thanks

  • @babblecamp
    @babblecamp Před 3 lety +1

    Thanks this helped me a lot

  • @emmanueljacobkanagala6734
    @emmanueljacobkanagala6734 Před 3 měsíci

    Excellent👏

  • @QuestzO
    @QuestzO Před 6 měsíci

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

  • @elenahicks2094
    @elenahicks2094 Před 2 lety

    Very well presented. Thanks for the helpful tips

  • @MikeVince-kl8cl
    @MikeVince-kl8cl Před 27 dny

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

  • @everythingandanything2457

    This is very helpful!

  • @godfreyincmedia5862
    @godfreyincmedia5862 Před rokem

    Excellent explanation and content

  • @adanhabibhussein1941
    @adanhabibhussein1941 Před 7 měsíci

    Thank you so much.

  • @vegetasfitnesschannel446

    Awesome video helped a lot!

  • @nilimapriyadarshini2029

    thank you so much for this video

  • @Nikocasme
    @Nikocasme Před 2 lety

    Amazing thank you so much.

  • @giuliamarinangeli6353
    @giuliamarinangeli6353 Před 3 lety

    Thank you so much! You saved me

  • @AlokKumar-cl9mf
    @AlokKumar-cl9mf Před 2 měsíci

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

  • @rahulr6374
    @rahulr6374 Před 10 měsíci

    Life Saver!

  • @vivekdoke4554
    @vivekdoke4554 Před 3 lety +1

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

  • @Maram_71
    @Maram_71 Před rokem

    Thank you so much🙏🏿🙏🏿🙏🏿🙏🏿🙏🏿

  • @SUNCITYSHRED95
    @SUNCITYSHRED95 Před 4 měsíci

    Thanks!

  • @Alcyeragraeth
    @Alcyeragraeth Před 3 lety +1

    Thank you so much

  • @ejtpun1066
    @ejtpun1066 Před 4 lety

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

  • @simonsiagian6725
    @simonsiagian6725 Před rokem

    many thankssss