Copy your range.
Right click where you want to paste
<Paste Special...
Check "Transpose"

--
Regards,
Dave


"Kincal" wrote:

I have an array with each cell containing formulas, and I want to transpose
it such that all the formulas in the cells stay the same and original and
transposed arrays are linked to each other.

I need the answer really badly

Thank You