Horizontal formula results from vertical table

[Bennyton]

Hey all, this is my first time posting and i suck balls at excel,

what I'm trying to do is perform a calculation vertically,
and display the answers horizontally,
but its an ever growing spreadsheet
so i'd like to be able to drag the results to display them,
rather than typing and changing values each time,
D2 is divided by D3 here, and i'd like to display that in c33,
then in D33, I'd like to be able to display D4 divided by D5...

if anyone could help me it would be amazing, im a college intern and this is killing my soul slowly!

 

[GlennUK]

How about:

=INDEX($D$1:$D$30,(COLUMN()-COLUMN($C$1)+1)*2)/INDEX($D$1:$D$30,(COLUMN()-COLUMN($C$1)+1)*2+1)

?

 

[Bennyton]

Thanks Glen, this worked a treat!

 

[GlennUK]

That's great!