Pivot Table Filtering On A List?

I have a pivot table with a group # on the left, and team members on the right. There are multiple team members in each group, and each are on a separate line in the pivot table, like this:

Group #Team1chrisdawnsally2cassiechrisdawnkathysally3jimjoejohntomGrand Total

I need to find where "sally" is on the team (easy to do"), BUT I need to display the rest of the team members in the group with her, like this:

Group #Team1Sally, Chris, Dawn2Cassie, Kathy, Sally, Dawn, ChrisGrand Total

Using the concatanate function to put them all into one cell and then filtering for "contains" was all I could come up with, but there are 14,000 groups