Transpose Maybe?

[Dan Oakes]

This has got to be very simple but I can't seem to figure it out...

On Sheet1 "A1" I have "=Sheet2!A1"
On Sheet1 "B1" I have "=Sheet2!A2"
On Sheet1 "C1" I have "=Sheet2!A3"

What function or symbol can I use to drag this formula so it keep this
pattern?
Is it transpose?

Thanks,
-- Dan

 

[Guest]

Put in A1 and copy across:

=INDIRECT("Sheet2!A" & COLUMN())

HTH

 

[Dan Oakes]

That's it... perfect.

Thanks Topper,
-- Dan

 

[Dan Oakes]

Actually, just a sec... What if my data starts on "Sheet2!B20"?

I tried this and it doesnt work:
=INDIRECT("Sheet2!B20" & COLUMN())

Thanks again,
-- Dan

 

[Gord Dibben]

To transpose a column to row try this entered in A1 of Sheet1

=OFFSET(Sheet2!$A$1,COLUMN(A1)-1,)

Drag/copy across row1 as far as you need.


Gord Dibben MS Excel MVP

 

[Dan Oakes]

That's the one, thanks Gord.
-- Dan

 

[Gord Dibben]

Dan

=INDIRECT("Sheet2!B" & COLUMN()+19)

Entered in A1 of Sheet1


Gord

 

[Roger Govier]

Hi Dan

Try the non-volatile solution of
=INDEX(Sheet2!$B:$B,COLUMN(A1)+19)