How do you convert a list that runs vertically to horizoontally?

K

Kevin B

Copy the data you wish to transpose, then click EDIT in the menu, select
PASTE SPECIAL and check off the TRANSPOSE check box.
 
R

Ron Coderre

Try this:

Select the vertical range of cells
Edit>Copy

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

Does that help?

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

XL2002, WinXP-Pro
 
E

Elkar

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 "Transpose"
Click OK
Delete your old data

HTH,
Elkar
 
Top