Required Data Science & Analytics,Data Mining & Management freelancer for Excel - Merge 116 Excel sheets of Contact Data Into One Sheet job

We have 116 Excel files of Contact data to be merged and cleaned up.

We are looking to merge these sheets into 3-4 files.

The data in the finished Excel files will include the following columns (First Name, Last Name, Email Address, Phone Number, Address 1, Address 2, City, State, Zip, Tags, Territory)

We will provide an excel sheet that maps specific zip codes to 7 different sales territories for the Territory column.

Once the sheets are merged, we will need you to de-duplicate based on email address in some sheets and de-duplicate based on Phone Number in others.

The Tags field could have multiple values or tags each comma separated within the field so that a contact can have more than one Tag.

Skills & Expertise Required

Data Science & Analytics Data Mining & Management