If you have two data sets
Set 1
1, 2
3, 4
Set 2
a, b
c, d
and you want to combine them to give something like
1, 2, a, b
3, 4, c, d
you need to find a way of linking set 1 and set 2. Otherwise who is to say that
1, 2, c, d
3, 4, a, b
is not correct?
So ... what is the link between your source data tables?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.