We have a spreadsheet with approximately 800 rows of data. We need to keep member ids together, but have the names in alphabetical order. If I sort alphabetically some children don't have the same last name, but need to be in a row below their parent. If I sort by employee id then all employees are out of order.....
Column Headers:
Last Name First name Relationship Code Employee ID
Any and all help appreciated.
Bookmarks