Say I have a data series going from A1 to E1. I would like to make a second copy of these cells going vertically, for instance from G1-G5. I can achieve what I want just by typing =A1 into G1, =B1 into G2 and so on. However, I have in mind a situation in which this needs to be done with a larger data series. I'm keen to economize on keystrokes if I can.
Is there a way to use Fill or some other command to achieve this?