How do I covert rows to columms?

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" <[email protected]> wrote in message
news:[email protected]...
>

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" <[email protected]> wrote in message
> news:[email protected]...
> >
>
>
>

"Mint" <[email protected]> wrote in message
news:[email protected]...
> "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.

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

You can select more than one row at a time.
--
David Biddulph