trying to make Vertical-Horizontal Flip....but how ?

[VICTOR5]

hi to all experts,

I am wondering the way to flip horizontal values to vertical values :

here I want : in curve sheet, range A2 to A12 all data should be link from

Data Sheet range B1 to L1 respectively & the same formula for Curve Sheet Column B & C.

I tried my self to define a Index Formula but i failed. In this regard i need your help pls.

Thanks

Irfan Khan


Note : I know the Transpose command
for review please check my example sheet as attached.

[lmp]

Hello,

In cell A2 use

=INDEX(Data!$1:$1,ROW(A2))

copy down. This gets you the dates. For the other values, use a different row, for example for the BL cost use

=INDEX(Data!$2:$2,ROW(A2))

and for the actual cost use

=INDEX(Data!$3:$3,ROW(A2))

You can combine the Index formula with a calculation, for example for the percentage in column D, use

=INDEX(Data!$2:$2,ROW(A2))/Data!$L$2

and for the percentage in column E use

=INDEX(Data!$3:$3,ROW(A2))/Data!$L$2

All formulas start in row 2 and need to be copied down.