Hi guys. Base on the examples below, in Table 1, I have Column A with names and Column B with their ranking. I want to be able to pull these name(s) to Table 2. I used the formulas - Index & Match but I'm only able to pull David.. Tks in advance!

Table 1
David 1
James 1
Mary 3
Susan 2

Table 2
1st David, James
2nd Susan
3rd Mary