I've been researching for quite a while and I cannot find the solution to this problem. I need to switch the values of some rows and columns in excel and I saw that I could use transpose, put the array I need to swap and press CTRL+SHIFT+ENTER.
I am doing that but the result is that it just copies a single cell, the 1st one, nothing happens to the other ones selected in the array.
I am using Office 2010 and this is the result. Any idea what could be happening and how I could fix it? Thank you!