Hello,

I have a spreadsheet that list employee information and also provides information on their dependents. I need to put this spreadsheet in Alpha order. The problem is, if a spouse or child has a different last name than the employee, they don't stay together. The spreadsheet provides an ID Number that the EE and their dependents all share. I tried sorting by last name first, then by ID number (and vice versa) but I can't get it.

For example:
Column B - ID Number
Column D - Last Name

ID Number Last Name First Name Relationship
001 Doe John EE
001 Smith Jane SP
001 Doe Jack CH
002 Myer Sam EE
002 Myer Mary SP


When I sort by last name, Sam and Mary stay together no problem because they have the same last name. But since John & Jane have different last names, they don't stay together. It seems I can either sort Alpha by last name or sort by ID, but not both. Any help?