Append 2nd Row to 1st Row

[pr4t3ek]

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...

[Paul]

Hi Pr4t3k,

If you're looking to put the first and last name in separate cells in the same row, then use the following formulas (assuming your original list is in A1:A??):

Please Login or Register  to view this content.

Fill both formulas down half as many rows as you have in column A (you'll only need half the number of rows since you're using one row instead of two).

If you really want to use a macro, which can be done, you'll have to specify where you want the results, and how you want to see them (one cell, two cells, etc.).

[pr4t3ek]

hey thanks for that, i guess that did answer my question...
but i dont think its going to work even with a macro only because i get various rows on various days etc....

thanks anyway! job welldone

[Paul]

I'm pretty sure we can get it to work with or without a macro. If the number of rows changes that's easy enough to overcome in either case.

If you let us know your worksheet layout(s) we can certainly get you up and running more efficiently.

[pr4t3ek]

the file is over 100kb for me to send via this forum.
& if i shrink it down, it wouldnt explain the whole story...