Excel cleanup: 202 messy rows → 180 clean rows (Sample work)

Sample work on synthetic data, not client work. This portfolio illustration describes a 202-row order-table cleanup: 22 duplicate records removed (7 exact and 15 near matches), leaving 180 rows. The illustrated output includes standardised dates, phone formats, spacing and casing, consistent blank cells, filters, a changes summary and a removed-records sheet.

Source-file status: the before.xlsx and after.xlsx workbooks are not currently attached to this page. The stated counts and transformation method have not been independently reverified from those original files. This illustration is not a downloadable or independently reproducible case study.

For a new cleanup task, the source file, duplicate rules, treatment of ambiguous values and acceptance checks are agreed before work starts.