Link and transpose?
 

I have data in rows in one worksheet that I want to have linked to columns in
another sheet. Is this possible?

Link and transpose?
 

In Sheet1 I entrered into A1:E1
111
222
333
444
555

In Sheet2 I entered into A1:
=OFFSET(Sheet1!$A$1,0,ROW()-1)
then copied A1 down to A5

That's one way....


"jaimek" wrote:

I have data in rows in one worksheet that I want to have linked to columns in
another sheet. Is this possible?

Link and transpose?
 

I have data in rows in one worksheet that I want to have linked to
columns in another sheet.

One way is to put this in Sheet2!A1:
=OFFSET(Sheet1!$A$1,COLUMN()-1,(ROW()-1))
and extend horizontally and vertically as far as needed