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

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