Clean and normalise our shipment Excel (18,653 rows)

Brief

Our shipment export has 18,653 rows with mixed port names, carrier names and dates. Normalise to UN/LOCODE, SCAC and ISO dates, remove duplicates.

Deliverable

Clean file plus a change log.

Acceptance criteria

• Ports mapped to UN/LOCODE
• Zero duplicate shipment IDs

Success metric

File loads into our BI tool without errors

Result

File normalised to UN/LOCODE and SCAC; duplicates removed.

Proposals (2)