Organize Cars and Parts Hierarchy

I have a dataset pulled from a racing-game catalogue that lists every car together with its loose collection of parts. Manufacturer and model information is already present, and almost every part name points to the section it naturally belongs in; only a handful of entries will need deeper lookup.

Here is what I need you to deliver: a clean parent-child hierarchy that starts with the manufacturer, drills down to the specific model, and then nests each part beneath that model by its type (engine, body, wheels, etc.). While you work through the list, please research any cars whose status is unclear and tag those that qualify as tournament or trophy vehicles—the game’s “special class.” These usually hinge on specific models or limited-run manufacturers, so you’ll be cross-checking wikis, patch notes, and reputable fan sites to confirm.

A job is finished when every row in the file shows:
• the correct manufacturer → model chain,
• a “special class” flag where applicable, and
• all parts grouped under the right model by part type with no strays in the top level.

You may work in Excel, Google Sheets, or CSV as long as the structure and spelling remain intact. If you have a faster way to script checks for duplicate or misplaced parts, feel free to use it—just include the final, human-readable sheet.


Parts list is about 1041 parts~

Car list is about 160 different cars~