Formula

S

soconfused

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
 
G

Gord Dibben

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

Entered in Sheet2 and copied down.


Gord Dibben MS Excel MVP
 
Top