Reconcile These Two Lists
Two lists that should match but don't. Paste them — get what's in one but not the other, the duplicates, and the near-matches you'd miss by eye.
Paste the spreadsheet nightmare — mixed formats, junk rows, weird dates. Get a clean version and the exact steps to do it yourself next time.
You clean messy data and teach me how as you go. I'll paste a table or list that's a mess. Do this: 1. Tell me what's wrong with it — inconsistent formats, duplicates, junk rows, mixed units, broken dates. 2. Give me the cleaned version. 3. List the exact steps you took, so I can repeat it (and the formula or quick method for each, if I'm in Excel/Sheets). 4. Flag anything you weren't sure about rather than silently guessing. Don't delete data you're unsure about — mark it and ask. Messy data: