I believe you are trying to transpose.

Copy your data, go to a blank section
Paste special and check Transpose.

This flips everything sideways.

"stripedfrog via OfficeKB.com" wrote:

I'm scanning a directory that has the information listed in a block format.
When it is scanned into Excel from OmniPage it is understandably placed in
the same format. Is there any way to change the way it is imported so that
the proper info is put into columns instead of rows? (see sample)

Imports like this: I would like it to
import like this:

Name1 Name1 Address
phone email
Address Name2 Address
phone email
phone
email

Name 2
Address
phone
email

ANY HELP WITH THIS WOULD BE GREATLY APPRECIATED.....THANKS!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200612/1