Pivot Table - How Do I Convert Data?

[Guest]

I have over 2000 rows of columnar data with the date in column "A", the day's
hi-medium-low named in column "B" and the data in columne "C" like the
following:


01/01/2000 Hi 69
01/01/2000 Med 51
01/01/2000 low 25
01/02/2000 Hi 87
01/02/2000 Med 42
01/02/2000 low 17
01/03/2000 Hi 64
01/03/2005 Med 48
01/03/2005 low 39

How do I rotate/convert it to the so that each day's date is in column "A"
and the range of Hi-med-low is in columns "B" "C" "D" respectively as below:

01/01/2000 69 51 25
01/02/2000 87 42 17
01/03/2000 64 48 39

 

[Dave Peterson]

Build the pivottable with the date in the rowfield.
the hi/med/low in the column field
and the qty/amount/price in the data field