Step 1: Replace Any Formula With Text


  Replace any formula with text in the range which you want to transpose.  

Step 2: Copy And Paste Transpose


  Now we can transpose our selection with copy and paste special.  

Step 3: Change The Transpose Range Back To Formula


  Now we just need to change the text in the transposed version back to formulas.   Now we have a transposed version of the original range and all the formula’s have maintained their original references.

How To Cut And Paste Transpose - 51