Is there a way that I can sort a column that user's may have multiple instances in and the group by the user while maintain the sort.

I have a list of certificates with various expiry dates and some user's have multiple certificates.

I would like to sort the results by expiry date and the group by user so I have a list of certificates that is sorted from soonest to latest and if a user who has a cert that expires next week also has a cert that expires in 2019 I will see the one expiring next week grouped with the cert from 2019. the next user who has a cert that expires in two weeks will appear next with any other certs that he has and so on.

I want to group certs by user but also have excel sort the certs by expiry date regardless of whether a user has one that expires in the future.

I tried the sort function and subtotal which kind of works but I do not want all of the subtotal noise I just want user cert after user cert.


Thanks

James