CSV product table cleanup demonstration

Self-initiated demonstration using synthetic product data, not a client engagement.

The source CSV contained duplicate rows, extra spaces and an empty row. I cleaned the data with a reproducible script: 10 rows became 7 after removing 2 exact duplicates and 1 empty row.

All 7 item IDs and prices were checked against the source. Leading zeros were retained. The image shows excerpts from the source and result.

The original file was preserved. Similar-looking records were not merged. Item IDs should be imported as text when opening the CSV in Excel.