Merging two tables with different column number.both tables have some column common name

[mido609]

If I have two tables for example the first one has 11 columns and the second one has 6 columns (and the 6 columns names already exists in the first one).

SO I need to join or merge the two tables to have the two tables in one table even If I have 5 blank columns for the second one.

to handle it for a small tables it is easy but for more than 300 row, I want to do it automatically using a macro or