Cleanup of a messy orders by Dmitrii BogachCleanup of a messy orders by Dmitrii Bogach

Cleanup of a messy orders

Portfolio project
Dmitrii Bogach
Cleanup of a messy orders export in Google Sheets. One date format, consistent SKUs, numbers instead of text, fixed lookups and no duplicate orders. In this sample, 133 of 1,107 rows were duplicates and revenue was overstated by $5,420. Sample data.

0 likes · 0 views · Oct 28, 2026

Cleanup of a messy orders export in Google Sheets. One date format, consistent SKUs, numbers instead of text, fixed lookups and no duplicate orders. In this ...

Tags