Computing.Net > Forums > Office Software > MS Excel - Change Row into Column?

MS Excel - Change Row into Column?

Reply to Message Icon

Original Message
Name: pvanh-htd
Date: April 12, 2005 at 07:20:54 Pacific
Subject: MS Excel - Change Row into Column?
OS: Win XP
CPU/Ram: 1GHz/256MB
Comment:

Hello,
Anybody know how to change the the data from rows into columns or say in the other word is to rotate a table in MS Excel?
Thank you very much.


Report Offensive Message For Removal


Response Number 1
Name: Bryco
Date: April 13, 2005 at 04:57:19 Pacific
Reply: (edit)

Select the data.
Right click, Copy
Right click, Paste Special, Transpose.

Bryan


Report Offensive Follow Up For Removal

Response Number 2
Name: pvanh-htd
Date: April 20, 2005 at 05:47:15 Pacific
Reply: (edit)

Thanks a lot. It works.


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: MS Excel - Change Row into Column?

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software




Have you ever used OpenOffice?

Yes, as my main suite.
Yes, occationally.
Yes, but only once.
No, never.


View Results

Poll Finishes In 5 Days.
Discuss in The Lounge