How to auto-fill reports like this (google sheets)

Question

i need to filter a report generated by a time tracking software. However the format delivered is not the best to filter. What i want as result is a list of employees (firstname, last name, department, sum(presence.Corona))

My plan was to use google docs and our HR department should paste this report each month in a new sheet. Then the first sheet generates the overview for each month-sheet. i could do this IF the firstname and last name would be in every line. Unfortunately it isnt. So i need to somehow automate that this is pasted in every line or i need to select all data and then group from (including) firstname 1 until (excluding) firstname 2 and so on.

At the moment i have no clue on how to do this. any ideas on maybe doing this with google sheets query feature?

Thank you for your ideas :)

I tried using google sheets query feature but i think i first need to fill the data