Forum Discussion
RESOLVED issue: TRANSPOSE function of Excel is not working (try the alternative C+S of the keyboard)
wendy20 Not sure if this helps, but I replicated your schedule and used both CSE and without (current MS365 version), without problems. Tested on both PC (Windows 10) and Macbook (Catalina).
As per the help pages, a #VALUE! error will occur when any of the cells are empty or contain text, or when the number of columns in array 1 is different from the number of row in array 2. You don't seem to have empty cells and the arrays are sized correctly. So, are you sure that all cells in both arrays are numbers?
Attached my file. See if it works on either of your machines.
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.
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.
