How do I covert rows to columms?

  • Thread starter Thread starter Guest
  • Start date Start date
Copy the data in the row, and then select the first destination
cell. Then go to the Edit menu, choose Paste Special, and check
the Transpose option.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Chip:

Since I have several rows, copying and pasting will take a long time. Is
there any othe way?
 
Chip:

Since I have several rows, copying and pasting will take a long time. Is
there any othe way?
Click to expand...

You can select more than one row at a time.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rows into Columms 1
How do I formulate total before Gst? 2
<ASK> How to add columm more than the default columm IV 3
formula to insert a row of consective numbers in a columm (1tru 5 2
Lookup or Match with rows and column together 5
Major Help Needed Asap 7
How do I give a name to my group? 1
Using Sumproduct in Autofilter 1

Back
Top