Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

excel - converting columns to rows

Posted on 1998-03-03
2
Medium Priority
?
555 Views
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?
thanks
Brett
brett@discian.con
0
Comment
Question by:baatkin
2 Comments
 
LVL 1

Accepted Solution

by:
Dimitri earned 200 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.
0
 

Author Comment

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

Thanks
Brett
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

926 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