Append 2nd Row to 1st Row

Hi,
This might be tricky ( but i think a loop might be able to do this?)

I've got data that should be on own row but its come into my excel file as two rows. This is going to be done daily, as a report so its not just once off, i need a macro or something.

so every second row should be appended to the right of each first row
e.g.

Row 1 First Name
Row 2 Last Name
Row 3 First Name
Row 4 Last Name
Row 5 First Name
Row 6 Last Name

I would like:

Row 1 First Name Last Name
Row 2 First Name Last Name
Row 3 First Name Last Name

Hopefully someone can help me with this...