software

How would you convert a spreadsheet from:

House
Car
Boat

to : House Car Boat

Try this:

Select the vertical range of cells
Editgt;Copy

Select the upper left corner cell of the destination
Editgt;Paste Specialgt; Check: Transpose
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;JHoleman1quot; wrote:

gt; How would you convert a spreadsheet from:
gt;
gt; House
gt; Car
gt; Boat
gt;
gt; to : House Car Boat

Copy the data you wish to transpose, then click EDIT in the menu, select
PASTE SPECIAL and check off the TRANSPOSE check box.
--
Kevin Backmannquot;JHoleman1quot; wrote:

gt; How would you convert a spreadsheet from:
gt;
gt; House
gt; Car
gt; Boat
gt;
gt; to : House Car Boat

Highlight your range of data
COPY
Select the first cell of your new range (cannot overlap with old range)
PASTE SPECIAL
Click the box for quot;Transposequot;
Click OK
Delete your old data

HTH,
Elkar

quot;JHoleman1quot; wrote:

gt; How would you convert a spreadsheet from:
gt;
gt; House
gt; Car
gt; Boat
gt;
gt; to : House Car Boat

Copy then Paste Special, Transpose

quot;JHoleman1quot; wrote:

gt; How would you convert a spreadsheet from:
gt;
gt; House
gt; Car
gt; Boat
gt;
gt; to : House Car Boat