Merge contents of 6 Excel files (no formulae involved)that contain basic contact information. Each file has slightly different formats, column headings and sequences, but the core, common contact information exists in each file. Largest file contains 132 rows, smallest contains 10 rows. No files contain more than 15 columns. Sample file attached.
The merged file must contain 100% of the data that exists in the input files, having the common data in the first 8 columns (First name, last name, business name, address, city, state, zip, phone).
The merged file must then have all likely duplicates removed and saved in a separate file.
The resulting "clean" file will then need to be checked against another Excel file and any likely duplicates between those two files must also be removed from the new file.