Copy paste data from a column to a row

[beanoburrito]

Hello all,

I'm currently trying to paste data that I have arranged in columns into a row format instead.

Example: I Say you have E69:E73 setup with SUM formulas for the above cells

(say E69 is SUM(E10:E18), E70 is SUM(E19:E127), ... etc)

and you want to paste that into a row format where the row/col isn't changed...

making E80:I80 the new cells that contain the exact same formulas.

Note that F69:F73, G69:G73, and so on, all also have the formulas that need to be pasted respectively into E81:I81, E82,I82, etc...

any ideas on how to do this without doing it manually?