Is there a formula/function to consolidate data into one line?

Good Evening All,

I seem to be in a bit of a bind. I messed up a report that I was working running. The end result left my "payment amounts" and "credit amounts" on different rows. I am trying to figure out some way (via VB or a formula) to make the amount in the "Credit amount" cell to appear in the same row, next to the Payment amount (that way all of my data is in one single row, not two).

My example is attached. The dollar amounts that I wish to move are in bolded red text. The cells that I want those amounts to go into are highlighted in yellow. For example, My very first Patient name is "Joe Schmoe" (row 2). His payment amount was $20.00 and his credit amount was $15.00. I want the $15.00 to appear in the "Credit Amount" column right next to the $20.00 payment amount.

Can anyone make sense of my question and give me a hand?

P.S. I have Excel 2007, but saved my attachment as .xls, for compatibility reasons. If you know of a simple solution that is specific to Excel 2007, please let me know!

Thank you so much in advance!