Expanding only visible groups

[SteveBExcel]

I have a very large spreadsheet with several groups of rows. The level 1 row in each group contains location data for a cable. The level 2 children rows contain details for that cable. When I filter the spreadsheet based on a location, all of the cables that have that location are visible but the details rows are collapsed. If I click the '2' to expand the rows, all groups in the spreadsheet expand. How do I only expand the groups with header rows that are visible?