like pivot table, with details?

M

Mike

Hi all,

is there any way to do a "pivot table" that instead of summing (or
averaging, multiplying, etc) the data fields, actually presents the data
field values?

I have a table that lists our purchased components part number, supplier,
customer, and program, i.e.:

P/N Supplier Customer Program
123B Jim GM Truck
123A Jim GM Truck
2413 Bob Ford Car
5231 Jim Ford Car
6789 Tom GM Truck


and I want to display it in a pivot table like format, i.e.


GM Ford
Jim 123B 5231
123A
Bob 2413
Tom 6789


Is there a quick/easy way to do this?

--

____________________________________________________________________________
________________
Please reply to newsgroup so everyone can benefit.
Email address is not valid (see sparkingwire.com)
____________________________________________________________________________
________________
 
Top