Append 2nd Row To 1st Row

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