You can use OFFSET, but it depends on the exact layout of
your data. Are there breaks between labels? Is the
city/state/zip in one cell or 3?

Take a look at some examples through a google search
using keywords "OFFSET" and "city". Here's one example:

http://tinyurl.com/5fffh

HTH
Jason
Atlanta, GA

-----Original Message-----
I have an employee who has saved a mailing list as the
actual address labels
within Word. We have pulled this listing over to Excel
wanting to change it
from the current layout to a more practical database
style listing

The format is currently

Name
Company
Address
City, State Zip

We would like to transpose each "label" into the
following format without having
to physically cut an paste.

Name Company Address City State Zip

Temporary solutions we have started trying is to use the
Array Forumla
Transpose. This at leasts pulls 1 label into a row, but
is there a macro or
other way to do this more efficiently?

I know I have seen something similar here but can not
find it.


Thanks!



.