Add the count of each department as the rowspan to the first department cell of each department, easy with count and row_number over (partition by department)

😎