I'm sorry if this question has already been answered. I've been searching for a solution to this problem and can't find anything that works. I also can't find an intelligible way to write the issue I'm having so if you need further clarification let me know.

I have a workbook (Sort Test.xlsx) where multiple rows belong to the same "group". Is there a way to sort by a value (e.g. name of the test, date of the test, etc.) while maintaining the formatting and keeping the "groups" together? There are 3 sheets in the work book. The first shows the sheet as is, the other two are examples of how I would like to be able to sort the data.