Transpose in excel doesn't work, it just copies one cell

Question

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!

Answer 1

You need to select a 2 col by 3 rows range before entering the formula, e.g.

The range can be larger - then all result cells not included in the (untransposed) source range are filled witn #N/A; if the result range is too small (like in your example) you get only a subset of your source table transposed.

Answer 2

Select E8 through F10 and array enter:

=TRANSPOSE(A1:C2)