Grouping duplicates together in a table

Hi, I am wondering how to group and filter duplicates together in a table variable?
Example:
Column 1 Column 2
A Paid
B Pending
C Paid
D Not Paid
A Paid

How do I group and filter out duplicates in the above table such that I have the following:
Column 1 Column 2
A Paid
A Paid

Thank you!