Word does not have a built-in function for this (a macro could be used) but
Excel has a transpose function that does exactly what you want.
Copy the cells in Word and paste into Excel.
In Excel, copy the cells you just pasted.
To paste the cells transposed, click in the upper-left cell of the paste
area (must be outside the cells you copied €“ could be on another sheet).
Click the arrow to the right of the Paste button and select Transpose.
--
Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word
"ndp" wrote:
How do I convert a column with 41 cells to a row with 41 cells?
The information I have is in word in paragraph form. However, I need to
have a spreadsheet with each of these paragraphs as a header of a column. I
have a column of paragraphs (cells) that needs to become a row with each cell
as a header of a column.
Thanks