TRANSPOSE worksheet function

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

I tried to use "Transpose" function to copy 1R x 4C array
(A1:A4) to a 4R x 1C array as follows:
I entered the same formulae =Transpose($A$1:$A$4)
to each of the following cells A2, B2, C2,D2.
I only get the value of the first cell from the original
array returned in the new array.

Anyone has experience with this function? Please help.
Thanks
 
What's the point of select part of the array you are transposing, that would
mean that A2 will be in
D2 as well? Nevertheless, you have to select the cells and then array enter
the formula
with ctrl + shift & enter
 
Jan,

Highlight the entire range (4R x 1C) you want to contain the transposed
array

Type the formula in the active cell

=TRANSPOSE(A1:C1)

and enter as an array using Ctrl+Shift+Enter and the formulas will appear in
{}'s

PC
 
Good catch Peo,

From the first part of his question, I thought he was just transposing to
some area of his sheet removed from the original range. He would actually
end up having the value from A1 in A2 and B2...I don't get it.

tim

| What's the point of select part of the array you are transposing, that
would
| mean that A2 will be in
| D2 as well? Nevertheless, you have to select the cells and then array
enter
| the formula
| with ctrl + shift & enter
|
| --
|
| Regards,
|
| Peo Sjoblom
|
|
| | > I tried to use "Transpose" function to copy 1R x 4C array
| > (A1:A4) to a 4R x 1C array as follows:
| > I entered the same formulae =Transpose($A$1:$A$4)
| > to each of the following cells A2, B2, C2,D2.
| > I only get the value of the first cell from the original
| > array returned in the new array.
| >
| > Anyone has experience with this function? Please help.
| > Thanks
|
|
 
Back
Top