Link and transpose?

J

jaimek

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

JMay

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....
 
M

MyVeryOwnSelf

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

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
 
Top