On 11 Oct, 09:31, "Roger Govier" <roger@technology4unospamdotcodotuk
wrote:
Hi Rich
in C1
=INDEX($A$1:$B$100,INT((ROW()+1)/2),MOD(ROW()+1,2)+1)
copy down as far as required.
--
Regards
Roger Govier
wrote in message
...
Hi,
In column A I have First Name, In Column B I have Surname. There are
over 2000 rows.
I need column C to have Firstname A1 in C1, Surname B1 in C2, so that
I end up with a single list of names, First Name above each Surname.
(This is to paste into something else)
I really don't want to manually key in the cell references. I'm sure
this should be easier than I'm finding it.
Any ideas?
--
Rich
http://www.richdavies.com
http://www.richdavies.com/excel.htm
http://www.mysatnav.info- Hide quoted text -
- Show quoted text -
Thanks Roger,
Thats nearly working, for some reason it's giving me blanks for the
First Name, but the Surname is OK.
--
Rich
http://www.richdavies.com
http://www.richdavies.com/excel.htm
http://www.mysatnav.info