Data Selection

J

jdpf

What I have is a list of 1500 name and address labels. The "names" are in
cells A1, A9, A17, A25 and so on, all are 8 rows apart. The "addresses" are
in cells A2, A10, A18, A26, all 8 rows apart. the city, state and zips are
in cells A3, A11, A19, A27 and so on all 8 rows apart also. I need the names
in one column, addresses in the next column and the city state and zip in the
next. I have done this before but I can't remember how.
 
G

Gary''s Student

In B1 enter:
=INDIRECT("A" & ROW()*8-9+COLUMN())
Copy B1 to C1 thru I1
Then copy B1 thru 1 downward
 
J

jdpf

Thanks a million. Worked lide a charm!

Gary''s Student said:
In B1 enter:
=INDIRECT("A" & ROW()*8-9+COLUMN())
Copy B1 to C1 thru I1
Then copy B1 thru 1 downward
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top