Can you extend a formula horizontally while the data is vertical

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.

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" <Shannon@discussions.microsoft.com> wrote in message news:3FC12D26-D7E7-4C66-B233-CA5B693B8E2E@microsoft.com...
> 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.

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" wrote:

> 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" <Shannon@discussions.microsoft.com> wrote in message news:3FC12D26-D7E7-4C66-B233-CA5B693B8E2E@microsoft.com...
> > 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.
>
>
>
>

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


On Mon, 19 Dec 2005 14:57:02 -0800, "Shannon"
<Shannon@discussions.microsoft.com> wrote:

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