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 |
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) |