I change the formulas to text:
Select the range
Edit|Replace
what: =
with: $$$$$=
replace all

Then I do the copy|paste special|transpose

Then I change both ranges back to formulas:
Select the range
Edit|Replace
what: $$$$$=
with: =
replace all
(and repeat with the other range)

HAS wrote:

As we all knew, Excel can copy values and then paste them with tranpose, can
we do the same for formulas?

--

Dave Peterson