Combine and fill Names & Addresses in 2 lines?

C

clubchamp04

I have 2 vertical sets of data (Names and Addresses) which I would like to
combine into 1 list that alternates Name then Address then Name then Address
and so on vertically.
 
G

Gary''s Student

Lets say the names are in column A and the addresses are in column B. In C1
enter:

=OFFSET($A$1,(ROW()-1)/2,MOD(ROW()-1,2)) and copy down.

Here is an example of cols A & B & C:

name1 addres1 name1
name2 addres2 addres1
name3 addres3 name2
name4 addres4 addres2
name5 addres5 name3
name6 addres6 addres3
name7 addres7 name4
name8 addres8 addres4
name9 addres9 name5
name10 addres10 addres5
name11 addres11 name6
name12 addres12 addres6
name13 addres13 name7
name14 addres14 addres7
name15 addres15 name8
name16 addres16 addres8
name17 addres17 name9
name18 addres18 addres9
name19 addres19 name10
name20 addres20 addres10
 
C

clubchamp04

Hey, Thanks a lot. How much trouble would it be to add a blank row between
each pair of Name and Addresses? Also, which part of the formula refers to
the location of the second collumn (if the 2 I am using are separated by more
than 1 space)?
 
Top