Forum Discussion
wendy20
Sep 27, 2020Copper Contributor
RESOLVED issue: TRANSPOSE function of Excel is not working (try the alternative C+S of the keyboard)
Hi there, I have encountered an issue with an excel array function using a Windows computer. I am sure the formula and items in the function are all used correctly. I can replicate the same o...
Rajesh_Sinha
Steel Contributor
The formula in cell b123 is not an array ( CSE ) formula, otherwise Excel must enclose formula with { } braces/curly brackets. Please upload the file you are using and let us examine it. Once move to b123 press F2 and hit Ctrl+Shift+Enter simultaneously.
wendy20
Sep 27, 2020Copper Contributor
Hi Rajesh,
I have figured that the issue is not about my input, rather it is my excel's functionality on TRANSPOSE.
It simply wouldn't allow me to transpose anything. The excel just left hanging whenever I hit C+S+E.
Thanks for asking!