3
1
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?
1This is my preferred technique. But as with all formulas like this, be aware that CUTTING rows or columns within the noted ranges may affect the remaining results, watch for that and reenter the formulas to reset them if you do much of that. – Jerry Beaucaire – 2012-02-27T14:43:09.100