View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How to shift address info. from rows to columns?

Please do not multi-post.

See one reply in .misc
(A possible non-macro way)

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

Use xdemechanik
<atyahoo<dotcom for email
--------------------------------------------------
"Mark" wrote in message
...
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!