Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
type information in one column and second coloumn will know respo | Excel Worksheet Functions | |||
Duplicate Data -Adding information to another column in row & dele | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions |