Thank you Thank you. Works like a top.

"John Bundy" wrote:

Select all of the rows, copy, then in another column right click, paste
special, and select transpose at the bottom.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Dendy" wrote:

I have 6 rows of data that I would like to spread out over coluns


EX: John Jones
President
New Company
New Road
City
State
Zip

I would like to move them to one row in different columns with headings


Thanks for you help
Name Tital Company Position