Q&A for How to Group and Outline Excel Data

Click the "Data" tab, then come to the "Outline" section, then click the small arrow on the right bottom corner to "Show the Outline Dialog Box". From the settings, unclick "Summary Rows Below Detail."

While the document is open, go to "File," "Options," "Advanced," "Display options for this worksheet." Make sure "Show outline symbols if an outline is applied" is selected. This is necessary for every sheet where there are outlines/groupings applied.

You need an empty row between your two groups. Otherwise Excel will automatically merge them.

Select the heading letters of two columns and right-click on one of them. Then select "Insert" from the right-click options. The new columns will be added to the left of the selected columns.

Write a macro that determines if the cell color is red. Then place an asterisk or other sortable value into an extra column. Sort that column, then collapse based on that sort.