How to shift address info. from rows to columns?

M

Mark

I have a mailing list with name, address, city, state & zip with each item in individual rows like a list of labels and a few empty rows of space between each listing. How do I create/transfer this list into columns accross so I can sort by city or zip? Thank you
 
M

Max

Please do not multi-post.

See one reply in .misc

--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com for email
--------------------------------------------------
Mark said:
I have a mailing list with name, address, city, state & zip with each item
Click to expand...
in individual rows like a list of labels and a few empty rows of space
between each listing. How do I create/transfer this list into columns
accross so I can sort by city or zip? Thank you!
 

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

Similar Threads

Drop down lists in seperate columns 5
Mailing address block: sorting 1 row to columns 1
Merging from an Excel file with graphics 1
Transpose multiple Columns to rows 8
Moving info from rows to columns 2
Vlookup v. drop down box for mailing addresses 1
Address List 3
How to use matching values in two worksheets to return another value 5

Top