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?
 
Top