Chip:

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

"Chip Pearson" wrote:

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



"Mint" wrote in message
...