| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
TRANSPOSE()
Friends,
I know how to copy / paste special / transpose, but I cannot get the TRANSPOSE() worksheet function to work. Let's say I have 1,2,3 in the horizontal array A1:C1. What, exactly, do I do to transpose the 1,2,3 into a vertical array in (A1:A5), using only the TRANSPOSE() worksheet function. I keep getting the #Value# error, so I must be missing something. Thanks for your help ... Bill Morgan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i past link and transpose simultaneously? | Excel Discussion (Misc queries) | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
| Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
| mailing list transpose help | Excel Discussion (Misc queries) | |||
Threaded Mode
