You have 2 ways.
First is to write custom SQL query manualy for your request and loop that data.
Second is to loop your data on standard way, save in multidimensional array, filter, transform and reorder that array via PHP how you need and after that loop that data and print like content.
Booth ways are good but my recommendation is to write SQL query because is faster and cleaner.
Like I know WP don’t have a done solution. You need to build by own.
You need to build custom template for that special category and do that there.