Each month I get hourly temperature data in this format:
Row1: 05/01/04 hour1, hour2...
Row2: 05/02/04 hour1, hour2...
I need to transpose the columns(hours1 through24)so they
are listed into one columnthis must be done for each day
of the month. It should look like:

05/01/04 hour1
05/01/04 hour2
05/02/04 hour3...

05/31/04 hour24
For the month of May, I would have 744 rows and one
column. I would like to right code that would do this to
selected data. I am using Excel 2002. Thanks!