Excel Data Validation Cleanup

I need a meticulous Excel specialist to take a raw spreadsheet that was generated from PDFs and turn it into a reliable, analysis-ready file. The job centres on data validation and cleanup, making sure every row is accurate, unique, and complete before I import the sheet into our reporting workflow.

Here are the exact pain points you’ll be tackling:
• Duplicate entries
• Inaccurate data
• Incomplete records

Your process can follow any efficient method you prefer—Power Query, formulas, or VBA—as long as the finished workbook meets these acceptance criteria:

1. All duplicates removed with the surviving record containing the most complete, correct information.
2. Obvious errors (misspellings, shifted columns, invalid numbers or dates) fixed or flagged for my review.
3. Empty but required fields either populated from other sources in the sheet or highlighted for follow-up.
4. A brief change log outlining the main corrections made, so I can audit the work quickly.

Once complete, send back the cleaned Excel file along with the change log, and the task is done.