I need this done within 24 hours. This is simple job for someone with experiene manipulating excel files.
1. I need these two files combined to a single excel file.
2. Then you will need to delete all the duplicates if the LASTNAME, FIRSTNAME and DOB MATCHES.
3. Then you will need to standardise the street address to be identical in format to Column O in the file named 2.xlsx
4. All names should be converted a single row. That is rather than LAST NAME, FIRST NAME, MIDDLE NAME, I will need a single row with the persons full name. That is SMITH, ADAM, DANIEL, will become ADAM DANIEL SMITH.
4. Then where you have more than one person with the same last name at the same address it needs to become a LASTNAME FAMILY. Thats is:
ADAM DANIEL SMITH
and
SUZY Q SMITH
will become SMITH FAMILY.
Any duplicates with same LAST NAME FAMILY and identical street addresses will be deleted.
