Can you extend a formula horizontally while the data is vertical

S

Shannon

I am trying to link a data from another worksheet and extend that formula to
the right. However the data on that other worksheet is vertical not
horizontal. Is there a way for a link to extend horizontally from a vertical
data table? I can not change the orientation of the data.
 
D

David McRitchie

Hi Shannon,
How about Transpose, depending on your data and what
you are actually copying.

see Help, Transpose rows to columns or columns to rows
 
S

Shannon

Hi Dave,
Problem is I am not copying, I am hitting the "=" button and creating a
formula reference to another tab, so Transpose is not a option. I asked
someone here and they thought about some "Rotate" function. Does Rotate
exist?

Thanks

David McRitchie said:
Hi Shannon,
How about Transpose, depending on your data and what
you are actually copying.

see Help, Transpose rows to columns or columns to rows



---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Shannon said:
I am trying to link a data from another worksheet and extend that formula to
the right. However the data on that other worksheet is vertical not
horizontal. Is there a way for a link to extend horizontally from a vertical
data table? I can not change the orientation of the data.
Click to expand...
Click to expand...
 
G

Gord Dibben

Shannon

Sheet1 has the data in Column A

Enter this formula in Sheet2 A1

=INDEX(Sheet1!$A:$A,COLUMN()) drag/copy across row 1.

Note: a sheet has 256 columns so you're limited.


Gord Dibben Excel MVP
 
Top