Formatting columnar data to a monthly matrix

[erikaaboe]

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

 

[Guest]

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