excelcutout.jpg

I need to format the above to look like this:

excelcutout2.jpg

The list is very long with it formatted like this. I need one column with the dollar amount and the adjacent column with the name and for it to repeat all the way down the list. Note some addresses have 2 lines.

How can I do this? I'm trying to learn excel macros but am stuck here...

Thanks for the reply!