Keeping data grouped when Filtering

[JCT77]

I have a spreadsheet where each column has a header cell ("Status, Priority,
Responsiblity, etc). Then I have the data broken up in groups, with one row
acting as the group header. (Software, Electrical Mechanical, etc) I want to
filter the data to only show items where the Status cell contains 'Complete'.
But I want my groups to stay in tact, leaving the row headers in place. What
is the best solution?

 

[Dave Peterson]

Put that grouping value on every row that should be displayed.

 

[JCT77]

I would like to avoid that if possible. I have so many rows it makes the
spreadsheet look really busy.

PS. Sorry about the multiple posts. It gave me two errors saying my post was
not submitted. But apparently they did)