Multiple Fields pulling into a summary form

Here is some sample data. I am trying to take this spreadsheet and pull the player name and salary to a summary form for that team. Example, Lewisberry chose Hank Aaron in rd 1 and Bill Castro in rd ...