Excel Data Merge & Dedup
Budget: ₹100 – ₹400 INR
I have several Excel files and worksheets holding a mix of text and numbers that now need to live in one clean, master sheet. Your task is straightforward: copy every record into a single worksheet, then identify and remove any rows that are exact duplicates. No partial-match logic is required—only full-row, like-for-like matches should be deleted.
You may rely on standard Excel features such as Power Query, built-in “Remove Duplicates,” advanced filters, or a quick VBA routine—whatever gets the job done accurately and repeatably.
Deliverables
• One consolidated workbook containing all unique records
• A short note (or second tab) summarising how many rows were imported, how many exact duplicates were found, and the final unique count
I’ll supply the source files as soon as we start, and I’m happy to answer clarifying questions along the way. Accuracy matters more than speed, but I would like the cleaned file back within a day if possible.
You may rely on standard Excel features such as Power Query, built-in “Remove Duplicates,” advanced filters, or a quick VBA routine—whatever gets the job done accurately and repeatably.
Deliverables
• One consolidated workbook containing all unique records
• A short note (or second tab) summarising how many rows were imported, how many exact duplicates were found, and the final unique count
I’ll supply the source files as soon as we start, and I’m happy to answer clarifying questions along the way. Accuracy matters more than speed, but I would like the cleaned file back within a day if possible.