Pivot Table List

**greenjl7** · 08-06-2012, 10:03 AM

I have a spread sheet with lists of people that are broken down by their position.
Example: Manager l Supervisor l Worker l Supplier

I am working in 2003 and would like to list out these names in a Pivot table for the drop down look....but I can only seem to do this with "Totals" for each group. If I just want the list, is there a way to do this, or a better way than a pivot table?

**oeldere** · 08-06-2012, 10:05 AM

Depending on how your data is stored, it will be possible, to see the position and the underlaying names.

**greenjl7** · 08-06-2012, 10:12 AM

it is a list of names in each column
Manager l Supervisor l Worker....
Mike Joe Steve
Mike Joe Carl
Mike Glenn Bill
Josh John Terry

etc

**oeldere** · 08-06-2012, 10:18 AM

Post an exel example (without confidentional information) and i will see what i can do for you.

**greenjl7** · 08-06-2012, 10:38 AM

This shows what I have....and what I would like to seepivot table help.xls

**oeldere** · 08-06-2012, 11:01 AM

See the attachment.

Is this what youre up to?

**greenjl7** · 08-06-2012, 11:05 AM

That is what I'm looking for but I don't want the "total" Rows in there.

**oeldere** · 08-06-2012, 11:09 AM

I don't know if it's possible to delete the total.

Normaly a pivot table is used to count / presentation of value's.

It is not good for text items only.