| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
| Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Hybrid Mode
