Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert column to row
I have numbers arranged in a column that I need to put in another application
by copy and paste. The other app only accepts data arranged in a row with a maximum of 25 at a time. How do I convert the column into a row in excel so I can copy and paste in a group of 25 instead of one at a time? Thanks Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert column to row
You can copy and paste special transpose. That should work.
Alternatively there is a TRANSPOSE command built in to excel. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert column to row
Hi S Davis,
I tried it . It works but numbers briefly flash and then cells go blank! Bob "S Davis" wrote: You can copy and paste special transpose. That should work. Alternatively there is a TRANSPOSE command built in to excel. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert column to row
Try ticking 'values' as well, and pasting it into a seperate sheet.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions |