Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .