| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine and fill Names & Addresses in 2 lines?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine and fill Names & Addresses in 2 lines?
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 -- Gary''s Student - gsnu200773 "clubchamp04" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine and fill Names & Addresses in 2 lines?
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)? "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200773 "clubchamp04" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a list of names and addresses? | Excel Discussion (Misc queries) | |||
| How do I have a cell fill in addresses from another file when I t. | Excel Discussion (Misc queries) | |||
| Contacts' names & addresses | Excel Discussion (Misc queries) | |||
| Range names and their associated addresses | Excel Worksheet Functions | |||
| How do I build a database of names and addresses? | Excel Discussion (Misc queries) | |||
Hybrid Mode
