Hi,
I have two worksheets with the same column headers and a unique key in common, Name. I need to merge the two to create a single worksheet with complete records.
The cases that will be encountered are:
- there will be exact duplicate records, of which i only want to keep one
- there will be unique records in each worksheet which i need to retain
- one worksheet will have blank fields that are filled in on the second worksheet. i need to merge the records to create a single complete record
- there will be cases where each worksheet has a record for Name and has field entries that do not match, in which case i need worksheet one to take precedence
Please see attached example with Worksheet 1, Worksheet 2, and Merged worksheet.
I've searched for days and can't find an answer on how to accomplish this. I thought about reading both tables into access but i have no experience with Access and when I try to bring them both in it doesn't like that the data is duplicated.
Can anyone help me?
Thanks!
Bookmarks