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.
