Excel or Access problem

Excel
Hi, I have this probelm in Excel I am trying to deal with, problem is this:

Spreadsheet 1 has customer address Field names in single fashion so it looks like this
cell A1 address 1 – 30
cell B1 address 2 – streetname
cell C1 address 3 – postcode

spreadsheet 2 simply has:
cell A1 address – 30 streetname postcode

Is there any way i can get all the data from sheet1 to sheet2. so it will convert 30 trail street edinburgh from spreadsheet 1 into the three different categories in spreadsheet 2. e.g.

address 1 = 30
address 2 = trial street
address 3 =edinburgh