excel - converting columns to rows

Posted on 1998-03-03
Last Modified: 2012-06-27
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?
Question by:baatkin

Accepted Solution

Dimitri earned 50 total points
ID: 1610827
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.

Author Comment

ID: 1610828
Wow, my excel ignorance is revealed once again.


Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Install MS Office 2016 and uninstall MS Office 2010 3 53
Getting product key for Office 2011 for Mac 9 202
Oart.dll 2 45
PC freezes and shutdowns becoming more frequent 17 104
Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now