Excel Product Data Cleanup Automation - 21/06/2026 02:10 EDT

I have a workbook filled with product data that needs to be transformed into a clean, analysis-ready format. Right now it suffers from three core problems: duplicates, missing values, and inconsistent formatting.

Here is exactly what I need done:
• Remove every duplicate record while preserving the first correct instance.
• Detect and fill missing values using logical Excel formulas (e.g., IFERROR, VLOOKUP / INDEX-MATCH, or other approaches you find robust).
• Standardize all text, date, and numeric fields so they follow one clear, uniform style.
• Convert each raw range into an Excel “Table” object, laying the groundwork for dynamic formulas.
• Build one pivot table that summarizes key product metrics and link an easy-to-read chart to that pivot so I can refresh insights with a single click.

Deliverables
1. A cleaned workbook containing the original sheet (kept for reference) and a separate, fully cleaned Table sheet.
2. A pivot table sheet plus an associated chart, both driven by the cleaned Table.
3. A short note or comment block explaining the main formulas and any assumptions you made.

Acceptance criteria
• No duplicate Product IDs remain.
• Blank or invalid cells are addressed with transparent formulas or, where appropriate, clearly indicated placeholders.
• All columns follow the agreed format (text case, date style, currency, etc.).
• The pivot and chart update correctly when new rows are added to the Table.

If you have strong, proven skills in Excel formula work and data organisation, this should be straightforward. I’m looking forward to sending you the file and seeing it come back streamlined, documented, and ready for reliable reporting.