Auto Parts Data Cleanup

Starting next week I will be onboarding data from five new auto-parts vendors, all supplied in Excel workbooks. I need a detail-oriented specialist to move each vendor’s catalog into my master sheet and, while doing so, strip the “Year / Make / Model” text out of every product description. Those three elements must land in their own dedicated Year, Make, and Model columns, leaving the description field free of vehicle-specific data.

The source descriptions don’t follow a single template—there are a few recurring patterns, but nothing perfectly consistent—so this is not a simple search-and-replace job. It will take a careful eye (or smart use of Excel functions, Power Query, VBA, or regex-driven tools) to isolate each vehicle reference without damaging the rest of the text.

Deliverables
• One cleaned, fully populated Excel file per vendor, with the new columns accurately filled and the descriptions trimmed.
• A brief log of any rows you’re unsure about so I can review edge cases quickly.

Please tell me when you can start, how many hours you can devote in the first week, and your hourly or per-line rate. I’m happy to answer questions or provide sample rows if that helps you estimate the effort.