Excel Dataset Cleaning & Merge
Budget: ₹12,500 – ₹37,500 INR
I’ve pulled up to three raw extracts straight from our production database and need them transformed into one dependable master spreadsheet. The job centres on strong Excel know-how, with an emphasis on formulas because that’s my preferred route; if you need a touch of Power Query or a light VBA helper to keep the workflow smooth, that’s fine as long as the final workbook runs cleanly in a standard Excel environment.
Here’s the core of what has to happen:
• Standardise every field name so column headers are uniform across all inputs.
• Correct any lingering formatting issues—dates, numbers, text case, you name it.
• Eliminate duplicates entirely, leaving each record represented only once.
• Flag mismatches: inconsistent data types, missing values and any conflicting information that crops up when the files are compared.
Deliverables
1. A single, pristine master file containing every unique record, ready for immediate business use.
2. A concise change log or brief summary outlining the key cleaning steps, assumptions and any edge cases you encountered, so the process is transparent and repeatable.
Accuracy and a quick turnaround are paramount. When you reply, walk me through your step-by-step plan, the specific Excel functions or techniques you’ll rely on, and your estimated timeline to completion.
Here’s the core of what has to happen:
• Standardise every field name so column headers are uniform across all inputs.
• Correct any lingering formatting issues—dates, numbers, text case, you name it.
• Eliminate duplicates entirely, leaving each record represented only once.
• Flag mismatches: inconsistent data types, missing values and any conflicting information that crops up when the files are compared.
Deliverables
1. A single, pristine master file containing every unique record, ready for immediate business use.
2. A concise change log or brief summary outlining the key cleaning steps, assumptions and any edge cases you encountered, so the process is transparent and repeatable.
Accuracy and a quick turnaround are paramount. When you reply, walk me through your step-by-step plan, the specific Excel functions or techniques you’ll rely on, and your estimated timeline to completion.