I will clean, dedupe and format a messy spreadsheet

China

I speak English

Excel reconciliation and printable design

Yima Delivery does spreadsheet work and print-ready design. Reconciliation: two lists that should match but don't. You get a six-tab workbook (summary, missing left, missing right, field mismatches, d...
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