drag formula down from columns that go acros

  • Thread starter Thread starter jc9972003
  • Start date Start date
J

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
 
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
Click to expand...

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
 
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
Click to expand...

Thanks
 
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
Click to expand...

Thank you
 
Back
Top