Combine two column using formula and based on player name

Hi,

In sheet1 have the raw data with playername, Runs and wickets.

sheet2 i need output. I need to combine the runs (highest value) and wickets (lowest value match with highest value) based on player name.

for example:

Player name is praveen.

Praveen highest wicket is 4 and corresponding lowest runs is 6

Output is highlighted in yellow color in sheet2.

Attached spreadsheed