|
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 |
Pivot Table - How Do I Convert Data?
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 |
| All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com