I will clean, dedupe and format a messy spreadsheet
Excel reconciliation and printable design
About this Gig
You exported three years of orders, and now the sheet has four spellings of the same customer, dates in two formats, and amounts stored as text.
I turn it into a table you can actually sort, filter and pivot.
WHAT YOU GET
1. Duplicates removed - exact matches and near matches (Zhang Wei / zhang wei / ZHANG WEI).
2. Dates, numbers and currency converted to real values, not text.
3. Extra spaces, trailing tabs and full-width characters stripped.
4. One short list of every change I made, so nothing disappears silently.
HOW I WORK
- Your original file is never edited. You get a new file plus a change log.
- When two rows look like the same person but might not be, I do not merge them. I flag them for you.
- Blank cells are reported, not filled with guesses.
- One revision round is included in every package.
WHAT I NEED FROM YOU
The file, and one sentence about what the sheet is for. If you have a rule for what counts as a duplicate, tell me - otherwise I use names plus one more matching column.
Business data only. Please remove passwords, card numbers and medical records before sending.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Power Query
•
Excel
•
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Formulas
•
Cleaning
•
Data validation
