Transpose drag-and-drop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dbodd - 12 Jul 2006 06:30 GMT

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.

Signature

dbodd

Reply to this Message

Ardus Petus - 12 Jul 2006 07:08 GMT

One way:

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

HTH
--
AP

> 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.

Reply to this Message

Ardus Petus - 12 Jul 2006 07:15 GMT

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

HTH
--
AP

> 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.

Reply to this Message

dbodd - 13 Jul 2006 06:50 GMT

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

Signature

dbodd

Reply to this Message