View Single Post
  #1   Report Post  
jnix
 
Posts: n/a
Default how do I transpose columns and rows

I have a spreadsheet as follows:

DonorId Date Amount
1 5/4/04 100
1 7/5 04 50
2 1/5/04 200

I'd like to change it to:

DonorId Date Amount Date Amount
1 5/4/04 100 7/5/04 50
2 1/5/04 200
3

There are about 3,700 rows and the number of dtes per donor vary.

Any ideas oon how I can do this?

Thanks,
jnix