Forum Discussion
Excel Array not working
I am trying to use the transpose function. This is the formula i type in: =TRANSPOSE(A2:C2) after which I press Ctrl+Shift+Enter. But instead of getting a column of data, I only get one cell of dat...
Rifat350 did you try just Enter? Now with dynamic arrays, Ctrl-Shift-Enter may be used to explicitly request a single value for compatibility with prior functions. It seems a little backwards but I haven't read much about it, just know that I tried your example and that is how it is working (i.e. just hit Enter and I get the array)