Excel Spread Sheet CSV File Change

I currently have spreadsheet which contains address which and date which i need to convert so i matches the CSV file format so i can upload it into my system correctly. I need this doing asap.

I have the address file and the the customer address format , which i have moved as much data as possible , i need to move the address over which i am having problems with.

I need to convert the McCarthy and Stone File onto the Customers address.