Kite shop orders
Weekly order lines from a fictional kite retailer with three regional stores.
What's messy
- Region spelled inconsistently (spaces, case)
- Some quantities missing
- One duplicated order
- Cancelled and pending orders mixed in
Columns
| Column | Type | Note |
|---|---|---|
| OrderID | text | Keep as text: leading zeros |
| OrderDate | date (yyyy-mm-dd) | |
| Region | text | Needs trimming and case cleanup |
| Product | text | |
| Qty | whole number | May be blank |
| UnitPrice | decimal | |
| Status | text | Complete, Cancelled or Pending |
Try these
- Trim and capitalise Region
- Filter to Complete orders
- Remove the duplicate
- Revenue by region
Preview (first 8 rows)
| OrderID | OrderDate | Region | Product | Qty | UnitPrice | Status |
|---|---|---|---|---|---|---|
| 0001 | 2026-04-18 | South | Tail Ribbon | 1 | 32.18 | Cancelled |
| 0002 | 2026-03-24 | South | Reel | 2 | 12.82 | Complete |
| 0003 | 2026-03-17 | south | Stunt Kite | 7 | 47.3 | Cancelled |
| 0004 | 2026-04-08 | NORTH | Tail Ribbon | 2 | 43.9 | Complete |
| 0005 | 2026-04-24 | SOUTH | Tail Ribbon | 1 | 7.22 | Pending |
| 0006 | 2026-04-08 | South | Reel | null | 38.43 | Complete |
| 0007 | 2026-04-28 | South | Stunt Kite | 1 | 43.34 | Complete |
| 0004 | 2026-04-08 | NORTH | Tail Ribbon | 2 | 43.9 | Complete |
All data is fictional. CSV cells that could be read as spreadsheet formulas are prefixed with an apostrophe.