This solution provided by a QB user works:
https://bigredconsulting.com/products/summarize-payroll-data-in-excel-fixed/
