Highlight the cells you want your values transposed to (eg B11 if your original values are in A1:A3), and enter
=TRANSPOSE($A$1:$A$3)
Then press SHIFT+CTRL+ENTER to put this in as an array function (it develops curly brackets. Et voila.
fatih
excel only allows 256 columns so you wouldn't be able to transpose any number of rows greater than that. that limitation aside, another option for transposing is to use paste special>transpose on the edit menu
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.