Sort and Group

actrak welcome to the forum.

It will help if you upload an Excel file (*.xlsx) with data laid out as you envision and expected outcomes (hand typed if necessary). 20 to 30 rows of data is usually enough. Please no screen shots or pics.

If you are unfamiliar with how to do this:
To attach a file to your post,

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

If you are filtering, turn it off. Select the entire range you wish to sort, including headers.

On the Home Ribbon, select Sort & Filter...>Custom Sort. The Sort Dialog Box will appear.
Make sure "My data has headers" box is checked.
Set Level 1 : "Column/Sort by" = "User", "Sort on" = Values, "Order" = A to Z
Click "Add Level" (Top Left)
Set Level 2 : "Column/Then by" = "Expiry", "Sort on" = Values, "Order" = Oldest to Newest
Now Click OK. Hopefully, you like what you see!

BTW, you could easily use conditional formatting to draw a border between users. If interested, please start a new Thread. - Lee

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee