Merge two data sets

[GoBrewers14]

I have two data sets that look like this

1)

========================================

ColumnA     ||  ColumnB     ||  ColumnC     ||  Column D

========================================

     x                    x                    x                    .

     y                    y                    .                    y

     z                    z                    .                    z

and 2)....

========================================

ColumnA     ||  ColumnB     ||  ColumnC     ||  Column D

========================================

     x                    x                    .                    x

     y                    y                    y                    .

     z                    z                    z                    .

I have missing values in the last two columns in each data set.  I want to merge (1-to-1) the two data sets and I want the values from table 1 to go in the cells with the missing values in table 2 and the values in table 2 to go into the cells with missing values in table 1.  I tried to use MERGE but this one-to-one match replaces all columns with just the columns from the 2nd data set which just ends up being the same thing.  Any ideas?

Thank you.

-john

[Reeza · Accepted solution]

Look into an update rather than a merge or join.

[GoBrewers14]

Rezza-

I think this is what I am looking for.  Thank you.

-John