October challenge board
Dirty Data Lab™ · Challenge 05
Very Easy
Thursday, October 15 · 5 minutesThe Five-Minute Cleanup
No trick this time. This is the easy square in the middle of the puzzle book.
The assignment
Cleanup rules
There is one finished state. Use the rules to get the board there.
- Delete the fully blank row.
- Remove the exact duplicate lead.
- Trim names and cities and use title case.
- Lowercase and trim emails.
- Sort by lead_id ascending.
Loading the puzzle board…
Loading your Lab profile…
Pass the puzzle
Send this one to a friend.
The friend link carries Dirty Data Lab™ referral attribution, so referred signups can be measured separately from newsletter and ad traffic.
Take the habit into Google Sheets
Practice here. Preflight real sheets with CTS Guard.
Clean That Sheet Guard checks the active Google Sheet for duplicates, missing data, formatting issues and other handoff problems before you share or import it.