Hello Robotboy94 and Welcome to Excel Forum.
I am not sure that I can give you a solution, or even that one exists, however it would be easier for someone to help if you would upload the spreadsheet from which the screenshots in post#2 were taken.
I am assuming that the bottom screen shot shows your desired results. If that isn't the case then please manually mock up what you wold like a filtered table to display.
To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.