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

I think I would start out just using the AutoFilter to group similar
items........then you maybe could do some CONCATINATION and re-filter on the
new columns if necessary........should show you some interesting
things.......

hth
Vaya con Dios,
Chuck, CABGx3




"Greg" wrote in message
...
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