Bill of Materials Cleaner — illustrative example

INPUT
BOM input rows: A-10, rev 1, 2 ea; A-10, rev 2, 3 each. Normalize unit spelling to each, preserving revision identity.

RESULT
part,revision,quantity,unit
A-10,1,2,each
A-10,2,3,each

Two revision-specific rows retained. Total listed quantity is 5 across distinct revisions, not an authorization to substitute one revision for another.

REVIEW
A bill of materials cleanup should preserve part identity and quantity meaning. Normalize formatting, but do not merge different revisions or units simply because descriptions look similar.

This is a teaching example, not a live execution record.