tables – How to show search results when the column isn’t there or will have too many results per row?

if I search for a User by "typing Bob" it might show 20 of them. But since I'm using a table, I can't show that many. Which is why I am showing the # of users. However I really need the ability to search by User or Deal.

The same issue can happen with Deal. If I search for “AUG” I might get 100 results for 1 Group or 1 row, so in total I may have 300 rows with 100 results per row. So I obviously can’t show that many deals. Which is why I am only showing a total # of deals. But if they search, what is the best way to show the matches? Would I put “Matched 2” after the # of total deals in a group?