What I would recommend at this moment, would be to use the Summary report, which you can export in Excel, and to use the “group by” option in order to sort the data the way you would like.
If I haven’t understood correctly what exactly you are trying to achieve, and if it would be easier for you, I suggest you contact our support team at support@clockify.me and share some more details.