Thread: How do you convert a list that runs vertically to horizoontally?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default How do you convert a list that runs vertically to horizoontally?
Try this:

Select the vertical range of cells
EditCopy

Select the upper left corner cell of the destination
EditPaste Special Check: Transpose
Click the [OK] button

Does that help?

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

XL2002, WinXP-Pro


"JHoleman1" wrote:

How would you convert a spreadsheet from:

House
Car
Boat

to : House Car Boat
Reply With QuoteReply With Quote