Extract data from 1st column while skipping blanks

Good morning,

I'm trying to create a sheet based off a pasted report I'll be getting daily. The report I get has a name in the first column which then shows daily hours below which start in the second column. At the end of each employee is a row that states "Total" and then has a number of different totals. The one column I need data from is the "Sold hours" column. I attached an xlsx file which has the report and I added a sheet with an example of what I'm trying to get. The problem I have is that I don't know how to have it list the names and sold hours on a sheet while not showing all the other daily values. Any help would be greatly appreciated.

Thanks
Mike