Clean Excel, Isolate Duplicates
Budget: ₹100 – ₹400 INR
I have several Excel sheets that mix text and numeric fields, and they need a careful round of data cleaning. The main issue is duplicate entries scattered throughout the columns. Rather than simply deleting or just flagging them, I want every duplicate row shifted to its own dedicated sheet while the original sheet remains with only unique records.
You can approach the task with any standard Excel techniques or Power Query if that speeds things up, as long as the final workbook meets these acceptance criteria:
• Original sheet contains unique rows only.
• A clearly-named “Duplicates” sheet holds every duplicate line, preserving full detail.
• No formulas should be left behind—values only—so the file stays lightweight for colleagues who may open it without calculation warnings.
Send back the cleaned .xlsx and a brief note on the steps or tools you used so I can reproduce the process next quarter.
You can approach the task with any standard Excel techniques or Power Query if that speeds things up, as long as the final workbook meets these acceptance criteria:
• Original sheet contains unique rows only.
• A clearly-named “Duplicates” sheet holds every duplicate line, preserving full detail.
• No formulas should be left behind—values only—so the file stays lightweight for colleagues who may open it without calculation warnings.
Send back the cleaned .xlsx and a brief note on the steps or tools you used so I can reproduce the process next quarter.