Need to get data from different cell numbers

Hello,

I have a list of invoices (hundreds) downloaded from some software into excel format. The downloaded data however lists invoice data as follows, occupying two rows.

123 GLOP968
5/21/2009 $1,206.58

In the above example: Invoice No 123 is in cell A1, Invoice Date 5/21/09 is in cell A2, Vendor Code GLOP968 is in cell B1, and Invoice Amount $1206.58 is in cell B2.

Now, is there a formula that I can use to transfer all this data in a new sheet showing data as follows:

Invoice No 123 is in cell A2, Invoice Date 5/21/09 in cell B2, Vendor Code: GLOP968 in cell C2, and Invoice Amount $1206.58 in cell D2.

Thank you and best regards,

Bobby