The four exports used different delimiters, date conventions and weight units. I applied the date rule for each source, converted grams and pounds to kilograms, parsed fees according to the source decimal convention and mapped the four status labels to a common value.
Duplicate or discrepancy?
Identical repeats can be logged and excluded. When the same event ID carries different values, both records need review. I retained those values alongside invalid dates, missing currencies and unsupported units so each problem can be resolved against the original file.
The reconciled workbook
The workbook accounts for all 640 input rows across 596 released movements, 32 rows on hold and 12 exact repeats. The clean table, change log, exceptions and source conventions let another analyst reproduce or challenge a particular transformation.


Standardized movement rows with the original source file and row, followed by the exceptions table.
0 likes · 0 views · Nov 17, 2026
Standardized four incompatible depot CSVs into 596 approved movements. The workbook reconciles all 640 inputs, including 32 held rows and 12 repeats.