How to capture 1st and 2nd place, accounting for ties

So I'm trying to "automate" a spreadsheet to accompany a board game. I need to track who's in first and second place, while accounting for ties... so for each of the columns, I'd need the following results:

A:

B:

C:

D:

^{All table formatting by ExcelToReddit}

All of my original data is captured in a single grid (like in my example), and I'm breaking out each "column" into a separate grid, currently sorted by that column value... basically, I just need to figure out how to combine "duplicate" values (all of the first place owners together, all of the second place owners together) to account for ties. The order of the names within the placements is immaterial (doesn't necessarily need to be alpha within the specific rank).

In the case of a tie for first, there would be no second place.

There will be another column on the right to show the "payout" for each placement, but I'm pretty sure I can figure out how to get the payout correct once I've got the correct number of names for each place.

Running 365 on Windows, if that changes anything.

Any thoughts?