Hi! In my worksheet:
Column A: Sunday
Column B: the date (2005-10-03)
Column C: hours in sunday (12pm, 1pm, 2pm, etc)
Columns D thru K: numerical values corresponding to that day

Instead, I want columns D thru K to be rows and column C (the hours) to be
rows.
So, right now it looks like:
D E F G H I J K
Sunday 8/14 0:00:00 2 4 6 3 2 5 6 2
Sunday 8/14 1:00:00 1 2 3 5 7 9 2 5
Sunday 8/21 0:00:00 3 5 3 2 7 8 3 7
SUnday 8/21 1:00:00 5 7 9 3 5 2 4 6

Instead, I want it to be:
0:00:00 1:00:00
Sunday 8/14 D 2 1
Sunday 8/14 E 4 2
Sunday 8/14 F 6 3
Sunday 8/14 G 3 5
Sunday 8/14 H 2 7
Sunday 8/14 I 5 9
Sunday 8/14 J
Sunday 8/14 K
Sunday 8/21 D
Sunday 8/21 E
Sunday 8/21 F
Sunday 8/21 G
Sunday 8/21 H
Sunday 8/21 I
Sunday 8/21 J
Sunday 8/21 K


Does anyone have any suggestions? Maybe some macro assistance? Right now,
I'm doing it by hand, but honestly, it's driving me crazy. Any help would be
wonderful right now.
Thanks!