ExcelBanter - How do I covert rows to columms?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I covert rows to columms? (https://www.excelbanter.com/excel-worksheet-functions/93576-how-do-i-covert-rows-columms.html)

Mint

How do I covert rows to columms?

Chip Pearson

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" wrote in message
...

Mint

How do I covert rows to columms?

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
...

David Biddulph

How do I covert rows to columms?

"Mint" wrote in message
...
"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

All times are GMT +1. The time now is 05:34 AM.