Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting columnar data to a monthly matrix
Hello-
I am trying to format time series data from a column to a monthly matrix. In other words - From this Date Hr1 Value Date Hr2 Value Date Hr3 Value .... into this Hr1 Hr2 Hr3 ... Date Value Value ... Date Value Value .... .... Any ideas on how to approach this? Thanks, Erik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting columnar data to a monthly matrix
A pivot table is an easy wasy to do this. DATE becomes a row field, HOUR
becomes a column field, and VALUE becomes a data item. The pivot table can also add totals, averages, etc. for you. Hope this helps, Hutch " wrote: Hello- I am trying to format time series data from a column to a monthly matrix. In other words - From this Date Hr1 Value Date Hr2 Value Date Hr3 Value .... into this Hr1 Hr2 Hr3 ... Date Value Value ... Date Value Value .... .... Any ideas on how to approach this? Thanks, Erik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting where Matrix intersects | Excel Discussion (Misc queries) | |||
Moving data in rows to columnar | Excel Discussion (Misc queries) | |||
repeating columnar data | Excel Worksheet Functions | |||
Comparing columnar data to row data | Excel Discussion (Misc queries) | |||
Matrix formatting | Excel Discussion (Misc queries) |