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!