Forum Discussion

Rifat350's avatar
Rifat350
Copper Contributor
Sep 03, 2020

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 data as shown below. 

 

Can someone help me figure out why the array formula is not working?

Btw, I am working on a PC not a Mac.

excel
Formulas and Functions

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Sep 03, 2020

    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)

Resources