Please help with macros to transpose Table 1 to Table 2.

Table 1
05/08/04 06/08/04 07/08/04 08/08/04
A A
B
C C C
D D D
E E

Table 2
Start_Date Course Duration
05/08/04 A 2
06/08/04 B 1
06/08/04 C 3
05/08/04 D 3
06/08/04 E 2