software

I have over 2000 rows of columnar data with the date in column quot;Aquot;, the day's
hi-medium-low named in column quot;Bquot; and the data in columne quot;Cquot; 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 quot;Aquot;
and the range of Hi-med-low is in columns quot;Bquot; quot;Cquot; quot;Dquot; 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:
gt;
gt; I have over 2000 rows of columnar data with the date in column quot;Aquot;, the day's
gt; hi-medium-low named in column quot;Bquot; and the data in columne quot;Cquot; like the
gt; following:
gt;
gt; 01/01/2000 Hi 69
gt; 01/01/2000 Med 51
gt; 01/01/2000 low 25
gt; 01/02/2000 Hi 87
gt; 01/02/2000 Med 42
gt; 01/02/2000 low 17
gt; 01/03/2000 Hi 64
gt; 01/03/2005 Med 48
gt; 01/03/2005 low 39
gt;
gt; How do I rotate/convert it to the so that each day's date is in column quot;Aquot;
gt; and the range of Hi-med-low is in columns quot;Bquot; quot;Cquot; quot;Dquot; respectively as below:
gt;
gt; 01/01/2000 69 51 25
gt; 01/02/2000 87 42 17
gt; 01/03/2000 64 48 39

--

Dave Peterson