Filtering to reverse filtering. What??

Hello community!   I have a bit of a complicated question so I will try to set up the scenario.   I have an Excel data table showing deal numbers, individuals working on the deal, and then the am...