To do this repeatedly you will need VBA. The actual code is straight
forward but the details of the code depend on the details of your data
layout. For instance, is there a blank row between listings? Or is the
number of rows per listing always the same?
If you wish, send me direct a file with a sample of what you have to
start with, as well as a few rows of what you want to have as the end
product. My email address is . Remove the "opq" from
this address. HTH Otto

"Lady Layla" wrote in 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!