Consolidate Customer Data in Excel
₹750-1250 INR / hour
Posted 1 minute ago
•
Ends in 6 days
₹750-1250 INR / hour
I have multiple Excel workbooks filled with customer contact details—names, phone numbers, email addresses—alongside their sales and order history. I need these files merged into one master sheet that is tidy, consistently formatted, and free of clutter. Here is what matters most to me: • Combine every worksheet into a single, well-structured workbook. • Identify duplicate customer records and keep only the most complete version of each record, discarding the rest. • Retain both the contact information and the corresponding sales/order history so each customer’s activity remains intact. • Apply clear, uniform column headers and date/phone/email formatting so the data is easy to filter or pivot in the future. Deliverable: A final Excel file (.xlsx) containing the consolidated, de-duplicated dataset, ready for immediate analysis. A brief “change log” sheet outlining any major cleaning actions you took (e.g., number of duplicates removed) would be appreciated.
Project ID: 40824014
About the project
1 proposal
Open for bidding
Remote project
Active 12 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗