Then, you need to have the new sheet pull the column B values from your originals into columns B and C of the new. Let's presume you'll put this in column A of your new sheet, as you've described. This is an easy copy-and-paste operation, which you will want to clean up using 'Remove Duplicates'. Otherwise it's not a match.ДЇirst, you need to make a sheet that contains all of the values that you want included from the A columns of each original sheet. So its only considered a match if both files have a row where the first 3 column entries are all the same. I REALLY need it to treat the first 3 column entries as one entry and compare it that way.

Now in actuality column A is actually 3 columns, I was just using one column as an example. Otherwise if the entry being added doesn't share it's corresponding A entry with the destination file it should be added as a new row with a blank B entry. So if they share a similar A entry then when the corresponding B entry from one file is added as the C entry of another it should be in the row of the shared A entry. What I need is for them to be merged according to the A column entry.

I want to add the column B from one file to another as column C, but the thing is that they have some rows under A that are the same in each file but some rows that are unique to each file. I'm trying to merge two excel files, here is the structure of the files:

Merging cells in excel 2003