R
rsegall79
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.
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.