I have a spreadsheet set up where each column has a header. (Status,
Priority, Responsibility, etc). Then amongst my data I have header rows,
breaking them into groups (EE tasks, ME tasks, etc) I want to filter the rows
where the Status cell contains "complete", but keep the groups together with
the headers showing. Example is below.

View before filtering

Status Responsibility
EE tasks
complete Jim
delayed Tom
complete Dave
ME tasks
delayed Joe
cancelled Sara
complete Sally


View after filtering

Status Responsibility
EE tasks
complete Jim
complete Dave
ME tasks
complete Sally


What is the best way to accomplish this?