filtering multiple columns in excek

[dshafique]

Hey guys, I'm trying to filter a report, but I want to filter multiple columns. for example, in column 1 I want to show the values "base" and "connect" and in column 2 I want to show the rows that contain "subgroup". however, the issue is, that rows that have base or connect in the first row, dont have subgroup that row for column 2.
is there a way to filter, or any alternative? thanks