For report tables that have sorting enabled, you can sort by multiple rows (similar to Excel).
First, sort by the first column like you normally would. Then, hold SHIFT and click a second (or third) column. It will then sort the records by the second row, while still keeping the grouping of the first row.