Rooney Kibet
I will clean messy Excel inventory & supply chain data
New to Contra
Rooney is building their profile!
BEFORE: Client had messy Excel inventory with 500 rows, duplicates (A12 / a12), blanks, wrong prices like "$ 2.5" and "N/A", and different warehouse names (KER / ker / Kericho).
AFTER: I did:
Removed 12 duplicate SKUs
Standardized item names to Title Case
Fixed QTY and Prices to 2 decimals
Unified Warehouse to Kericho
Made sheet ready for pivot dashboard
Result: Clean, ready-to-use inventory in 2 days using Excel.
Tools: Excel, Remove Duplicates, Text to Columns, TRIM, PROPER
1
30
Email & Phone Validation Cleaning
1
41
Text Standardization & Trimming
1
37
Duplicate Removal Project
1
35