Personal Excel cleanup demonstration
Personal demonstration using fictitious order data. Standardised whitespace, email casing, order IDs, dates and numeric formats across 30 source records. Removed four exact duplicates and produced 24 traceable order records.
Two conflicting versions were consolidated without guessing: disputed fields remain blank and the affected orders are marked for review. Zero units and a zero price were preserved as valid source values.
Includes original data, source-row references, a detailed change log and reconciliation controls. All 120 cleaned fields were checked against the source and seven reconciliation checks matched. Source and editable result files are available on request through Contra.
This is a personal project with fictitious businesses and example.com email addresses. No client data or client results are claimed.
1 like · 4 views · Oct 29, 2026
Personal demo: 30 fictitious source rows cleaned to 24 orders, with 4 duplicates removed and 2 conflicts flagged for review. No client work.
