I've worked with pivot tables quite a bit and I can't get
this to work. You can manipulate the data as far as
having it count, sum, take the product etc. But it does
not seem to work with non-numbers. I used ABC, DEF, etc.
as work order "numbers" and the pivot table shows 1's if
you select "count" and zeroes if you select "sum". None
of the other options helps either. Finally, you cannot
drag data within a pivot table unless you first convert
the table via copy/paste special/values to a non-
calculated table. So I'm not sure what you mean about
dragging. You can manipulate the source data but not the
pivot table itself (other than formatting and the other
built-in options). Too bad, because you're right: the
pivot table would be the way to go.....