Pivot Table - How Do I Convert Data?

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

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

Nick Krill wrote:
>
> 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