Pivot table problem multiple columns and headers

[Guest]

Thank you in advance for some advice. I am looking at analyzing Laboratory
specimen turn-around-time, and have identified discreet delays by specimen.
I have three columns headed with the titles "Order to Collect", Collect to
Receive in Lab", and "Receive to Verify". The data looks like this:

Order-Collect (") Collect-to-Receive in Lab (") Order-to-Receive in Lab
5 4 9
10 25 35
8 18 26
11 9 20
2 6 10
4 23 27

I had originally copied the data onto two long columns, but the number of
occurances are too many, now. Is there an easier was to do a pivot table
with either these three columns, or six columns with the header title next to
the time element such as:


Order-Collect (mins) Collect-to-Receive in Lab (mins)
Order-to-Receive in Lab
Order-Collect 5 Collect-to-Receive in Lab 4 Order-to-Receive in Lab
9
Order-Collect 10 Collect-to-Receive in Lab 25 Order-to-Receive in
Lab 35
Order-Collect 8 Collect-to-Receive in Lab 18 Order-to-Receive in
Lab 26
Order-Collect 11 Collect-to-Receive in Lab 9 Order-to-Receive in
Lab 20
Order-Collect 2 Collect-to-Receive in Lab 6 Order-to-Receive in Lab
10
Order-Collect 4 Collect-to-Receive in Lab 23 Order-to-Receive in
Lab 27

Thanks, this has me stumped...

 

[steven1001]

If you add an extra column called (say) 'OrderNumber' and fill in with
some sequence you can then put OrderNumber in the pivot table ROW and
each of the other fields you list in the data area. This looks like
what you were seeking but I confess to not understanding you comment
about 6 columns.

regards..