Hello,

I have a long list of data in one vertical column. It is a data value for every hour of every day of a year. I.E
------------------------------------
B C
1/1/2007 (hour 1) (data)
1/1/2007 (hour 2) (data)
1/1/2007 (hour 3) (data)
1/1/2007 (hour 4) (data)
.
.
12/31/2007 (hour 22) (data)
12/31/2007 (hour 23) (data)
12/31/2007 (hour 24) (data)

--------------------------------------------
I need to put the data in a format so each day has its own row with the data values to the right of the date. I.E.
-------------------------------------------------

R S T U AP 1/1/2007 (hour 1 data) (hour 2 data) (hour 3 data) ............ (hour 24 data)
1/2/2007 (hour 1 data) (hour 2 data) (hour 3 data) ............ (hour 24 data)
1/3/2007 (hour 1 data) (hour 2 data) (hour 3 data) ............ (hour 24 data)
.
.
.

12/31/2007 (hour 1 data) (hour 2 data) (hour 3 data) ......... (hour 24 data)

--------------------------------------------------
What is the best way to go about this? I posted the actual column numbers if anyone wants to write some actual code I can try. Any help would be appreciated otherwise I will be doing a whole lot of paste special. Thank you in advance!

Jake