Can excel organize my data into groupings?

Question

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.

Answer 1

First create a pivot table from your data, and then use the Sort option to sort your data.