drag formula down from columns that go acros

[jc9972003]

Help
I'M Linking a cell from anothe spreadsheet that goes across "columns"
and my spreadsheet goes down"rows" I need a formula that will let me just drag down and get the content below
Example
spreadsheet copying from

JAN FEB MAR APR
1 100 200 300


Mine
This would be the would be the answer and I want to drag down
Jan 100
feb 200
mar 300
apr

 

[Claus Busch]

Hi,

Am Thu, 25 Apr 2013 08:30:02 -0700 (PDT) schrieb (e-mail address removed):

spreadsheet copying from

JAN FEB MAR APR
1 100 200 300

Mine
This would be the would be the answer and I want to drag down
Jan 100
feb 200
mar 300
apr

you can copy and paste special => Transpose
Or you can write the month in column A and then in B1:
=HLOOKUP(A1,Sheet3!$A$1:$Z$10,2,0) and copy down.
If you want a formula for the month too, then in A1:
=INDEX(Sheet3!$A$1:$Z$10,1,ROW(A1))
and in B1:
=INDEX(Sheet3!$A$1:$Z$10,2,ROW(B1))



Regards
Claus Busch

 

[jc9972003]

Help I'M Linking a cell from anothe spreadsheet that goes across "columns" and my spreadsheet goes down"rows" I need a formula that will let me justdrag down and get the content below Example spreadsheet copying from JAN FEB MAR APR 1 100 200 300 Mine This would be the would be the answer and I want to drag down Jan 100 feb 200 mar 300 apr

Thanks

 

[jc9972003]

Help I'M Linking a cell from anothe spreadsheet that goes across "columns" and my spreadsheet goes down"rows" I need a formula that will let me justdrag down and get the content below Example spreadsheet copying from JAN FEB MAR APR 1 100 200 300 Mine This would be the would be the answer and I want to drag down Jan 100 feb 200 mar 300 apr

Thank you