I will clean and merge your messy excel and CSV data

You know the file. Headers starting on row 5, a merged title on top, subtotals in the middle of the data, numbers stored as text, and a tab called "pivot_DONTTOUCH" nobody wants to open.

I turn that into one clean table you can filter, pivot and trust.

WHAT I FIX

- Headers detected wherever they are, not assumed to be row 1

- Dates unified to one format, whatever they looked like before

- Numbers stored as text converted properly, EU and US separators

- Customer and product names unified across spellings, case and spacing

- Subtotals and blank separator rows removed from the data range

- Duplicates merged, and totals recomputed when they disagree

NOTHING DISAPPEARS SILENTLY

Every change goes into a "changes_log" sheet: the row, the rule applied, the value before, the value after and the reason. Anything I cannot resolve with certainty goes to a "flagged" sheet instead of being deleted or guessed.

Real example from my test file: 16 clean rows out of a sheet with 6 blank rows, 2 subtotals inside the data, 13 dates in five formats and 16 name variants that resolved to 5 real customers. Two rows were flagged.

Send me the file and I will tell you what is fixable.