This is probably a silly question... but how can I transpose some cells?

The cells I want to transpose are forumla's, so copy and pasting them
doesn't help.

Quite often I find myself making several comparisons of lists against
themselves, while theres probably an easier method I haven't got that far
yet, and usually end up needing to change something from Horizontal to
Verticle.
At the moment I have to manually enter all the cell references which is
tedious.

Eg.
I have various numbers along the top of the spreadsheet, starting at E1,
these come from Sheet2 where they are calculated.
I then want A5 to be the same as E1
I want A6 to be the same as F1
I want A7 to be the same as G1, etc