excel - converting columns to rows

How do you convert a column of numbers into a row of numbers? No calculations being done, I just want to switch  rows (columns) of numbers to the other.  Can this even be done - easily?
thanks
Brett
brett@discian.con
baatkinAsked:
Who is Participating?
 
DimitriConnect With a Mentor Commented:
You need to Transpose the data.  This is how you do it in Excel 97:

1. Select the range you wat to transpose from;
2. Choose Edit, Copy
3. Goto to your destination cell.
4. Choose, Edit, Paste Special, Select Transpose checkbox and click OK.
0
 
baatkinAuthor Commented:
Wow, my excel ignorance is revealed once again.

Thanks
Brett
0
All Courses

From novice to tech pro — start learning today.