Values in a column to rows based on multiple criteria

Question

I am trying to turn a the table on the left side to the one on the right.

How can it be achieved? I have tried This, but it did not work.

Answer 1

In I2 you should write this array formula (enter it using Ctrl+Shift+Enter):

=INDEX($C$2:$C$9,MATCH(1,($G2=$A$2:$A$9)*(H2=$B$2:$B$9),0))

Then you can copy it to other columns (K, M, O).