I did try transpose and got this

10/17/2011 BOB1 BOB2 BOB3
3:20:27
3:20:42
3:20:57
3:21:12
3:21:28
3:21:43
3:22:01


but the original sheet goest to cell IV (surprise) and then wraps
making it 9 sections of the same data with 1 blank line between each
section.
this stuff spans over 3 days.