Information from column to row
 

How do I transfer the information of a culumn to a row, typing is not an
option because the column is too long.

Thanks again to the all the people who answer and I hope some day I can help
someone else.

Mosqui

Copy the column, select the first cell in the row (can't be in the
copied column) EditPastespecialtranspose.

Regards
Rowan

Mosqui wrote:
How do I transfer the information of a culumn to a row, typing is not an
option because the column is too long.

Thanks again to the all the people who answer and I hope some day I can help
someone else.

Mosqui

Just a note here.

You mention the column is too long to re-type.

If more than 256 rows in the column, you cannot Transpose.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 09:28:33 +1000, Rowan wrote:

Copy the column, select the first cell in the row (can't be in the
copied column) EditPastespecialtranspose.

Regards
Rowan

Mosqui wrote:
How do I transfer the information of a culumn to a row, typing is not an
option because the column is too long.

Thanks again to the all the people who answer and I hope some day I can help
someone else.

Mosqui