troubleshooting Question

Sort by groups of rows rather than single rows in Excel

Avatar of Steve_Brady
Steve_BradyFlag for United States of America asked on
Microsoft Excel
5 Comments1 Solution265 ViewsLast Modified:

Is there any way in Excel (2007) to permanently tie groups of rows together?

For example, suppose you have a database with several hundred records and for several reasons (e.g. amount and type of data for each record, display purposes, etc.) it is most desirable to use five rows for each record rather than a single row.  

Now, suppose you want to sort the records for some reason.  In a typical sort, each row is treated separately and sorted against every other row.  However, in the scenario mentioned above, you would want each group of five rows to always stay together and be sorted against all other groups of five rows.

Is that doable?  If not, is there a good workaround or alternative approach that can accomplish the same thing?

Juan Ocasio
Continuous Process Improvement Lead

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros