Formatting - NEED HELP
 

I have raw data that I need to format. Column A lists client name, Column D
of same row includes total hours for that client, then in Column B/D
underneath that row lists all projects and hours per project for that client.
Then it starts again, next row following individual projects is a new client
name in Column A and total hours in Column D. I need to sort so that the
client with the highest total number of hours first (their name in column A
followed by the projects in column B) and then the next highest and so on and
so forth. Not sure this is even possible.