text to columns
 

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

text to columns
 

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

text to columns
 

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