How can I move Vertical data to Horizontal without changing formulaes?

[Mathman]

Hi


I have data with formulaes that is 50 Columns wide and each has 204 rows. I set it up this way to first be able to drag all the formulaes.

My issue now and question is, how can I change the 50 columns with 204 rows layout to have 204 columns with 50 rows and not add any addition formulaes to do so?


Any idea how I could do this other than manually moving each cell ?


Thank you
MM​

 

[Special-K99]

Depends what the formulas are