I have downloaded data from another program into excel. I want to put the
name and total hours worked on the same row. Here's how the data filled into
the
spreadsheet:

Ann Mon 7.5
Tues 7.5
Wed 7.5
Total 22.5

Cathy Mon 7
Wed 8
Thurs 7
Total 22

But, I want it to look like this -
Ann 22.5
Cathy 22

How do I do that?