This is a general question that someone may want to look at if they're bored.
I have a sheet that I use to record customer complaints. The sheet is rather
long and details which section of our organization it is and the people
managing that area. After I talk with customers I break up their response
into improvement areas. My sheet looks like this:

Area, Dept, Supervisor, Customer_Name, Comments, Improve1,Improve2,Improve3

A new Row is created when a survey is complete.
The improve order isn't important. I want to be able to look at this and
figure out trends with area or dept or supervisor, etc. I have exp using
pivot tables but not sure how to group the fields together or what the best
way to look at this. If anyone is interested in helping post any follow up
questions needed.
--
Greg