Hello to all - I have a table of customers with specific data for each. I have grouped some rows together by Company HQ as the lead row and it's subsequent Branch locations (again all specific data). When I go to sort, for example, by Company HQ then by Revenue - the collapsed group (Branch Locations) are sorted out individually in lieu of staying with their Company HQ.
Is there a way to keep the collapsed group of rows with their associated lead row? (forgive incorrect terminology - not an expert by any means.) Thank you!
Column 1 Column 2 Column 3
+Comp. A HQ $5000 Call <-- Lead Row
-Comp. A Branch 1 $2000 Email <-- Collapsed Row
-Comp. A Branch 2 $1500 Circular <-- Collapsed Row
-Comp. A Branch 3 $500 Email <-- Collapsed Row