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...
Bookmarks