Large Transpose of data

I need to transpose data from this...

0:00 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00
1/1/2011 Sat 1 Lane 1 (West) 158 124 68 34 22 18 29 41 47 99 143 168 188 242 267 279 291 324 324 220 152 131 90 150
1/1/2011 Lane 2 (West) 91 73 35 23 13 18 11 24 49 48 84 72 123 124 157 166 195 179 214 145 102 82 45 88
1/1/2011 Lane 3 (East) 90 65 65 31 24 21 27 33 47 82 113 148 148 194 161 178 182 179 168 122 80 85 71 109
1/1/2011 Lane 4 (East) 111 65 51 17 13 17 25 34 59 106 153 190 228 209 245 271 229 255 251 154 104 106 75 127
to this..


Lane 1 Lane 2 Direction total Lane 3 Lane 4 Direction total Hourly Total
(West) (West) (East) (East)
1/1/2011 0:00 158 91 249 90 111 201 450
1/1/2011 1:00 124 73 197 65 65 130 327
1/1/2011 2:00 68 35 103 65 51 116 219
1/1/2011 3:00 34 23 57 31 17 48 105
1/1/2011 4:00 22 13 35 24 13 37 72
1/1/2011 5:00 18 18 36 21 17 38 74
1/1/2011 6:00 29 11 40 27 25 52 92
1/1/2011 7:00 41 24 65 33 34 67 132
1/1/2011 8:00 47 49 96 47 59 106 202
1/1/2011 9:00 99 48 147 82 106 188 335
1/1/2011 10:00 143 84 227 113 153 266 493
1/1/2011 11:00 168 72 240 148 190 338 578
1/1/2011 12:00 188 123 311 148 228 376 687
1/1/2011 13:00 242 124 366 194 209 403 769
1/1/2011 14:00 267 157 424 161 245 406 830
1/1/2011 15:00 279 166 445 178 271 449 894
1/1/2011 16:00 291 195 486 182 229 411 897
1/1/2011 17:00 324 179 503 179 255 434 937
1/1/2011 18:00 324 214 538 168 251 419 957
1/1/2011 19:00 220 145 365 122 154 276 641
1/1/2011 20:00 152 102 254 80 104 184 438
1/1/2011 21:00 131 82 213 85 106 191 404
1/1/2011 22:00 90 45 135 71 75 146 281
1/1/2011 23:00 150 88 238 109 127 236 474


I have a years worth of data and I doing it by cut and paste will take forever.

HELP

here is a sample of the raw data and the result I want