Transpose year long hourly time-series

Correcting the hours across the top to 0 to 23 instead of 1 to 24,

Row\Col	AA	AB	AC	AD
2	2012-01-01 00:00	40318		AA2: =INDEX($A$2:$A$367, INT((ROWS(AA$2:AA2)-1)/24) + 1) + MOD(ROWS(AA$2:AA2)-1, 24)/24
3	2012-01-01 01:00	38406		AB2: =INDEX($B$2:$Y$367, INT((ROWS(AB$2:AB2)-1)/24) + 1, MOD(ROWS(AB$2:AB2)-1, 24) + 1)
4	2012-01-01 02:00	36501
5	2012-01-01 03:00	35305
6	2012-01-01 04:00	34568
7	2012-01-01 05:00	33501
8	2012-01-01 06:00	31650
9	2012-01-01 07:00	32109
10	2012-01-01 08:00	32981
11	2012-01-01 09:00	35063
12	2012-01-01 10:00	37709
13	2012-01-01 11:00	40771
14	2012-01-01 12:00	41374
15	2012-01-01 13:00	40913
16	2012-01-01 14:00	40577
17	2012-01-01 15:00	40865
18	2012-01-01 16:00	43536
19	2012-01-01 17:00	47675
20	2012-01-01 18:00	48918
21	2012-01-01 19:00	47909
22	2012-01-01 20:00	45597
23	2012-01-01 21:00	44366
24	2012-01-01 22:00	43556
25	2012-01-01 23:00	39163
26	2012-01-02 00:00	35115
27	2012-01-02 01:00	32570
28	2012-01-02 02:00	31784

You're welcome, man.