Transposing time series data
 

Hi,
I have a need to transpose time series data. I'll need to do this for a
number of spreadsheeets, so my thinking is that a macro to run on each sheet
would be the most efficient (it's actually 4 separate workbooks, each
containing around 5 sheets).

The data is currently in this format, more or less:

ID 12/31/05 12/31/05 12/31/05 1/31/06 1/31/06 1/31/06
Balance Contribution Withdrawal Balance Contribution Withdrawal
1 $100 $0 $75 $25 $0
$0
2 $500 $25 $0 $525 $0
$0


I need to get it to this format:

ID Date Balance Contribution Withdrawal
1 12/31/05 $100 $0 $75
2 12/31/05 $500 $25 $0
1 1/31/06 $25 $0 $0
2 1/31/06 $525 $0 $0

Thank you,
Craig