Formula

[Guest]

I have two worksheets that I am linking. One worksheet is set-up
horizontally and the worksheet is set up vertically.

In other words I am trying to copy columns A, B, C, D, to rows 1,2,3,4

Thanks

 

[David Biddulph]

The function you want is TRANSPOSE.

 

[Gord Dibben]

=INDEX(Sheet1!$1:$1,ROWS($1:1))

Entered in Sheet2 and copied down.


Gord Dibben MS Excel MVP