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
|