If you really want to transpose the values--not the formulas:

Select the range to copy
you can edit|copy
followed by edit|paste special, check values and transpose

if you really wanted to keep the formulas, you can do this:

Select the range to copy
edit|replace
what:  =  (equal sign)
with:  $$$$$
replace all

now the formulas are just plain old strings

Edit|copy the range
edit|paste special|transpose

Select both ranges (or do it twice)
edit|replace
what:  $$$$$
with:  =
replace all

And the strings are reconverted to formulas.