Insert a column Category and use: =VALUE(LEFT([@Code],2)) Then map: 31→Welding, 32→Paints, 33→Deck Stores, etc.
If you have the official IMPA PDF, you can use Excel’s "Get Data from PDF" feature (Excel 365). However, due to multi-line descriptions and special characters, expect hours of cleanup, deduplication, and validation. impa code list excel extra quality
It started six months ago when a tanker, the M/V Odysseus , rerouted to a non-standard dry dock in Jakarta. The official report cited “engine coupling fatigue.” But the unofficial report, the one Arthur had accidentally received as a misrouted CC, cited a single line item: 2)) Then map: 31→Welding