First off, my data sample:
EZ LOADER 1 FAIRMONT MOBI 1 FARMALL TRACT 3 FORD 5 FORD 700 1 FORD F-150 1 FOUR DOO 1 FOUR WINNS 1 GENERAL 3 GENERAL MOBIL 1 GMC 1
I have over 12k records like this. What I'm wondering is if I can possibly throw a CSV or list of "common" car makers at the list, and somehow cut them in to their own column or spreadsheet.
basically by the end of this I need to have the whole thing sorted as "car" "tractor" "other" etc.