Click level number "2" to collapse all the subgroups together, leaving only the grand ... To remove all column (and row) groupings in your spreadsheet, in the Data tab, click Outline > Ungroup ...