Apoligies if i've been vague.
Columns A and B with data that never change, but on Column C, D and E are not.
A B C D E F
Name Address USD 100 Paid
Name Address USD 250 Pending
If i can move the data on column C to the right it will do the trick.