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

On 15 Mar 2007 14:55:21 -0700, "Dan Oakes" wrote:

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