I have a list of families I need to sort by last name in column A. You can see that each child in the family has its own row. The problem is that when you apply sort by column A descending, it does not keep families together. Instead, it sorts rows individually, leaving the second and third child in each family (with a blank A column) at the bottom.
I'm looking to group families together, but the Group feature under Data was no help (it kept combining groups of adjacent families). Is there any simple way to do this? I was looking through some other posts and some even suggested VBA macros.