Looking up results of a certain criteria and displaying them all into one row

hi

I would need help in solving this difficulty that i'm currently facing. I have multiple results accumulated and I would like to display them based on their best results achieved.

are to any solution to achieve this result?

Attached is a sample workbook about what i'm talking about

Thanks!

Here without macro:

hI ZBOR, Thanks a lot!!your perfect solution is great!!. Thanks for your help