I have this:

date 1 amount 1 date 2 amount 2 date 3 amount 3 date 4 amount 4 date 5 amount 5
1 1/1/13 $2.00
1 2/1/13 $2.00
1 3/1/13 $2.00
1 4/1/13 $2.00
1 5/1/13 $2.00
2 3/1/13 $1.00
3 2/5/13 $2.00
3 3/9/13 $1.00

and need this
date 1 amount 1 date 2 amount 2 date 3 amount 3 date 4 amount 4 date 5 amount 5
1 1/1/13 $2.00 2/1/13 $2.00 3/1/13 $2.00 4/1/13 $2.00 5/1/13 $2.00
2 3/1/13 $2.00
3 2/5/13 $2.00 3/9/13 $1.00
how to transfer date and amount to go across , transpose will give two rows I want all in one, i need something simple
I am using excel 11 would like simple procedure like copy/post?
thanks for any help