Excel Data Consolidation & Cleanup
Budget: $250 – $750 USD
I have multiple Excel files that contain customer details such as name, address, suburb, postcode, and telephone number as part of delivery manifests for a freight provider. I'm looking for an Excel expert who can help me consolidate these files into a single, clean customer database. There are approximately 75 separate excel files and about 600 customers.
Key Tasks:
- Extract contact details from all files
- Merge all files into one without duplications
- Count and record how many times each customer appears across the separate freight manifests
The final merged file should be in Excel format and include the contact details along with an appearance count for each customer.
Ideal Skills & Experience:
- Advanced Excel skills (data extraction, merging, deduplication)
- Experience with data consolidation and cleanup
- Attention to detail to ensure accuracy in the final file
Key Tasks:
- Extract contact details from all files
- Merge all files into one without duplications
- Count and record how many times each customer appears across the separate freight manifests
The final merged file should be in Excel format and include the contact details along with an appearance count for each customer.
Ideal Skills & Experience:
- Advanced Excel skills (data extraction, merging, deduplication)
- Experience with data consolidation and cleanup
- Attention to detail to ensure accuracy in the final file