transposing multiple rows to a single row

I have a datasheet that contains multiple rows for each patient . each row contains patients ID, kidney stone type (caox, cap, ua, str etc.) and its precentage (upper table)
i would like to transform it to a table that has one row for each id, and this row will contain the precentage of the stones components which are written in the heading of each row (lower table)

i would appreciate any idea

thanks!

In B17 (array formula)

=IFERROR(INDEX($C$2:$C$12,MATCH(1,($A$2:$A$12=$A17)*($B$2:$B$12=B$16),0)),"")

Enter with Ctrl+Shift+Enter

Copy across and down

Or non-array

=IFERROR(INDEX($C$2:$C$12,MATCH(1,INDEX(($A$2:$A$12=$A17)*($B$2:$B$12=B$16),0),0)),"")

OMG
that is the quickest answer i have ever gotten

thanks!