On 11 Oct, 11:15, Teethless mama
wrote:
In C1: =OFFSET($A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))

copy down as far as needed



" wrote:
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 -

Works a treat ! Thanks !
--
Rich
http://www.richdavies.com
http://www.richdavies.com/excel.htm
http://www.mysatnav.info