How do I covert rows to columms?

C

Chip Pearson

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
 
M

Mint

Chip:

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

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

How do i get cumilative sum of values against specified criteria? 1
@How to add new worksheet on right side.... 0
How do I change the forecolor of a CheckBox when True 2
check if 2 cells are equal but only if they contain numbers not i. 1
can i copy a tab name into a field 1
How do I sort a proctected worksheet 2
Dealing with a Pivot Table (when I don't want to) 0
Worksheet functions in VBA 2

Top