Join or Merge Two Tables in Excel Using Microsoft Query - Easy!

Learn the basics of joining two tables together! It's actually pretty easy and thus, fun! Try it out!

Fantastic Developer Tools:

[mamtadesai]

Thank you for sharing this...Last night i wasted 3 hours figuring out which vlookup to apply to get desired result. This tutorial did what i wanted in 5 mins. Thank you soo much :)

[gyeonghunjo]

I've been searching for 3 hours to get this. It helps a lot like you said, Easy! Thanks a lot!

[chrisb]

This helped out a lot with an Auditing project for school. Thank you

[jwrona]

This was extremely helpful! Thank You. Anybody that this didn't work for missed the part about system tables in table options.

[oldelpaso]

Good tutorial. I'm wondering will this"querie table" automatically update if data is changed in the different tabs?

[InvincibleEntity]

Thank you very much for this video. You've just solved one of my life's greatest puzzles!

[SuperFlyingpan]

Thanks, helped me create a mad table for work, mofos are gonna be like "wow, mad table"!

[JamesBa]

This really helped me on a project with a very short deadline! Thanks for sharing.

[OfficialDivideByZer]

Worked perfectly for what I needed! Thanks!

[sivanesansethuraman]

Great. Nicely articulated in short span of time. It was useful for me, thank you !

[ehhemalahle]

thank you very much, saved me a day's work

[SammyVOfficial]

Excellent tutorial. Much better than other methods using vlookup or match functions. Thanks!!

[Tonya]

Exactly the answer I was looking for! Thanks!!!

[randrewright]

Thank you very much for sharing this. You saved me a tremendous about of time.

[Neddiek]

Thanks for this video, this is a cool tool I discovered in my new place of work, I have a task to recreate a query that has a search date criteria. This is to enable users to input a date range for the report they want to view. Any ideas on how to do this please.

[TheTrhome]

Anyway of replacing data in a column with something else before transferring it into Excel. Say you want to replace red with blue in column "colors"

[Wassalaam]

Hi Dan, thanks for the video! Small question: What if the tables are in different Excel files? How do you connect them?

[forzaalgiers]

Thank you, Dan for your Great efforts

[KillaMC]

awesome thanks now I see that all I was missing was to join them.. Id-id

[freemanesq]

Thank you. This was very helpful (2019)