Stages
Just playMission 1/6
Meet the pasted list
- The pre-orders arrived as one long column.
- Split it, clear the doubles, and watch what each button does to the tab.
Do thisMission 2/6
Split at the real separator
Do thisMission 3/6
Split first, then remove doubles
Do thisMission 4/6
Move the note, then clean
Do thisMission 5/6
Measure the look-alike orders
Do thisMission 6/6
Make the look-alikes truly match
★★★
Run cleared.
🚀 Push it
- 🟢Split a copy of the day column on the space, into empty columns; say what it gains.
- 🟡Add one order twice, spaced differently, and find out whether the clean-up catches it.
- 🔴Explain how a note nobody reads can stop a duplicate from going.
🌐 Make it for real
Open a blank spreadsheet in Google Sheets and build the sample list, split with its doubles gone.
Twist: type one order twice with an extra space inside and see whether the clean-up catches it.
🧑🏫 Teacher Guideclick to open
⏱ 53015
✅ Watch for
- Duplicates removed before the split, so odd spacing keeps a copy
- A note left in a far column, keeping its row unique
- Look-alike orders trusted by eye instead of measured with LEN