Transform data

[Dinar_15]

Hello everyone

Can anyone help me transform data from table one (blue) to table 2 (green). 

is there any formula I can use so I don't have to insert data manually? 

Thank you in advance for your help

[#2]

@Dinar_15 

See the attached demo. (I think your example contains some mistakes, if I understood your intention correctly)

[#3]

thank you for your fast response I already saw your demo. but I didn't make any mistakes in my example table. in another hand when I saw your demo the first and second row is correct but the rest does not match my example. table green is the result I wanted from the source data table blue. by the way, thank you again for trying to help.

*I want to try to explain further but I really bad at English

[#4]

@Dinar_15 

Can you explain why the lower left cell in the second table should be 6 while the lower left cell in the first table contains C?

[#5]

because in table blue Res5 put A in 6 (1-6:ranking). that's why the lower left cell in the second table should be 6.
like in table blue Res5 put C in column 1 (means ranking1) so in table green Res5 column C should be 1.

[#6 · Accepted solution]

@Dinar_15 

OK, I see what you want now. New version attached.

[#7]

oh that's awesome.. thank you so much