View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] erikaaboe@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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