Combing Two Rows into One Based on Person Number

Hello everyone,

We're working on the earnings report and there are some employees have two assignments for one year. We are looking for the solution to combine them into one row (Or maybe we can say group rows based on 'Person Number'?). Here are the details:

We use employee 101360 as an example, he has two assignments during that year, second is the latest active one. We hope can add two numbers in 'Absences', 'Imputed Earnings', 'Supplemental Earnings' and 'Total Earnings' together and use the latest date in column 'Hire date', 'Relationship start date' and 'Termination Date'. Column 'Person Number' and 'Display Name' are always the same.