Transpose drag-and-drop

[dbodd]

Suppose you have data 1,2,3,4,5 in cells G1-G5.

Now in A1 we have formula =G1, how can I drag into B1 to E1 to fill
with formulae =G2 , =G3 , =G4 and =G5 resp.

 

[Ardus Petus]

One way:

=INDEX($G:$G,COLUMN())

HTH

 

[Ardus Petus]

You could also use:
=TRANSPOSE(G1:G5)
entered in A1:E1 and validated with Ctrl+Shift+Enter (Array formula)

HTH

 

[dbodd]

HI Ardus Petus,
Many thanks for that. I had already found the
TRANSPOSE array solution , but I prefer the alternative using INDEX.