Cut vertical data from web site and paste horizontal.

[masterchief911]

I am trying to cut data from a site, (i.e. Name, address, city, etc) that is in a vertical column. I want to paste it in a horizontal manner so I can do mail outs. I try the past special under the paste tab in 2007 and all it gives me is the option to paste html, text and something else with radio buttons. Any thoughts?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>

 

[MWilliams]

I would try paste special > Unicode Text.

After you get it in, then copy what you just pasted and try Paste Special again and select Transpose.

I think that should do it if I understood the question.

 

[masterchief911]

Bingo, You are my new best friend.