How to join two tables in Excel 2016 [100% working solution]

In this video, you will find detailed instruction how to join/merge two tables/sheets in Excel 2016 without any additional tool. Very simple and easy explanation.
You can also find some other tutorials for Microsoft Office, and Excel 2016 in particular. Thanks for watching!

[ArminAlibasic]

Hello everybody, if you want to skip intro you directly to 1:03. Also, if you find this video useful, consider subscribing to my channel helping me to reach 1000 subscribers so I can monetize the videos again. In the future, I plan to make more videos with excel because now I will use it intensively.

[danyos]

Such a great tool and explanation on how to use it. Thanks very much for the well-detailed and well-explained video!

[andria]

This was one of the shortest and easiest explanation to what i was looking for. Thanks man!!

[Meemz]

THANKS ! Had two huge tables for proteomics and u just made it happen in seconds :D

[sebastianmoller]

This was very well explained. It was exactly what I was trying to solve, so thank you very much!

[guilima]

Just want to thank you for taking the time to create this video. It helped me a lot, and it is a great contribution as learning content to the YouTube community.

[busalem]

Exactly what I was looking for, explained in an easy way. Thank you very much.

[gustavoweingaertner]

Thank u so much! This is exactly what I was looking for!

[stranala]

This is exactly what i was looking for. Great explanation.

[zdn]

Thank you. A simple case is more helpful than a complicated one for beginners.

[glennisace]

Thanks mate. I'm saying the same as everyone else. This is exactly what i have been looking for. Works awesome. Cheers.

[AladineTK]

Thank you i was stuck at it, this solves the problem without any additional add-on

[Mariamsm]

This is exactly what I've been trying to do but I don't have Excel 2016! I have 2007 and google spreadsheets. How would you do this with an earlier version or in spreadsheets? Thank you!

[venusfly]

Wow you've just saved me a ton of time with about 30 spreadsheets I have to join..thank you so much for this informative video!

[samkab]

Hi suppose we have 20 sheets .do i have to format every single sheet as a table? How to save time for that?

[jairac]

me salvaste la vida, para el que quiere unir tablas es la solución ideal

[fufalj]

Selam brate!
:D

Look who I ran into? :) I'm very pleased that I found your video. Excellent explanation.

[FlylenseQ]

oh man, really beneficial. big thanks

[hariom]

Can you help with a sales situation?
For example: Let's take Burundi as a car dealership which sells 5 different cars. We need to get the inventory from another sheet which has inventory for all 5 Brands. Both sheets have Burundi as common but the cars brands are not in order. Help?

[danyos]

Excellent. Thanks, Archi Mne. This process is a life-saver. Very much appreciated you taking time to explain it. Best!