Vertical to Horizontal data

I have a lot of data that I need to change some cells from Vertical to Horizontal. I have been using the Copy, Paste Special, Transpose but I still would have to do this every client payment. Please see attached so you could see what Im talking about. I highlighted what I have been doing. Copying the 5 entries from the "Amount" column and pasting them horizontally with the Transpose option. As you can see, this report is huge. Is there an easier or quicker way to do this? Frustrated...