Power QueryExercises

Kite shop orders

Weekly order lines from a fictional kite retailer with three regional stores.

What's messy

Columns

ColumnTypeNote
OrderIDtextKeep as text: leading zeros
OrderDatedate (yyyy-mm-dd)
RegiontextNeeds trimming and case cleanup
Producttext
Qtywhole numberMay be blank
UnitPricedecimal
StatustextComplete, Cancelled or Pending

Try these

Preview (first 8 rows)

OrderIDOrderDateRegionProductQtyUnitPriceStatus
00012026-04-18SouthTail Ribbon132.18Cancelled
00022026-03-24SouthReel212.82Complete
00032026-03-17southStunt Kite747.3Cancelled
00042026-04-08NORTHTail Ribbon243.9Complete
00052026-04-24SOUTHTail Ribbon17.22Pending
00062026-04-08SouthReelnull38.43Complete
00072026-04-28SouthStunt Kite143.34Complete
00042026-04-08NORTHTail Ribbon243.9Complete

All data is fictional. CSV cells that could be read as spreadsheet formulas are prefixed with an apostrophe.