Forum Discussion
RESOLVED issue: TRANSPOSE function of Excel is not working (try the alternative C+S of the keyboard)
Hi Riny,
Thank you so much for helping me out with those efforts!
Yes, I am sure that all the cells in both arrays are numbers.
I have downloaded the file you've attached and tried to redo your working.
1. Cleared the existing content
2. Selected the right cells
3. Typed in the formula required
4. Tried to C+S+E *********The excel seems to be frozen every time when I hit these buttons. No response at all.
So I went back to trace the error. As shown in the evaluation of calculation, the first step on the TRANSPOSE(B10:G11) has already resulted in an error value.
I am suspecting that there are some issues with my Excel setting. What do you think?
Anyways, I really do appreciate you for taking your time and energy to help me.
Cheers!
wendy20 But did it work OK before you started redoing my formulae? Not sure why you get the value error. According to the help screens that will occur if you do NOT enter the formula with C-S-E where your Excel version requires it. You tagged your original post with "Office365". If that means that you are a MS365 subscriber using a current version of Excel, you wouldn't have to worry about C-S-E.
- wendy20Sep 27, 2020Copper Contributor
Yes, I can see the results of your working perfectly fine.
I just can't edit anything of the formula.
I believe I have the Office 365 Subscription. I tried to do it again by just hitting only E. The alert of ' you can't change part of an array' always pops out.
- Riny_van_EekelenSep 27, 2020Platinum Contributor
wendy20 Since you are not on MS365, try entering the TRANSPOSE portion of the formula only and hit C-S-E.
- wendy20Sep 27, 2020Copper Contributor