Combining 2 lists

[richdaviesdotcom]

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?

 

[Roger Govier]

Hi Rich

in C1
=INDEX($A$1:$B$100,INT((ROW()+1)/2),MOD(ROW()+1,2)+1)
copy down as far as required.

 

[richdaviesdotcom]

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











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

 

[Teethless mama]

In C1: =OFFSET($A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))

copy down as far as needed

 

[richdaviesdotcom]

In C1: =OFFSET($A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))

copy down as far as needed










- Show quoted text -

Works a treat ! Thanks !

 

[Roger Govier]

Hi Rich
Are you sure you copied it as posted?
It works absolutely fine for me.

=INDEX($A$1:$B$100,INT((ROW()+1)/2),MOD(ROW()+1,2)+1)