Spreadsheet: 807365d1669869026-excel-formula-to-convert-raw-data-to-my-desire-format-actual-data-with-actual-result-2-sumprodut-last-version
Sheet: Final result

 | Month | ADW Income Current Month | ADW Worked Days Current Month | Average Daily Rate
Employee1 | 2021-11-01 00:00:00
Employee1 | 2021-12-01 00:00:00
Employee1 | 2022-01-01 00:00:00
Employee1 | 2022-02-01 00:00:00
Employee1 | 2022-03-01 00:00:00
Employee1 | 2022-04-01 00:00:00
Employee1 | 2022-05-01 00:00:00
Employee1 | 2022-06-01 00:00:00
Employee1 | 2022-07-01 00:00:00
Employee1 | 2022-08-01 00:00:00
Employee1 | 2022-09-01 00:00:00
Employee1 | 2022-10-01 00:00:00
Employee1 | 2022-11-01 00:00:00
Employee1 | 2022-12-01 00:00:00
Employee2 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Employee3 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Employee4 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Employee5 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Employee6 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Employee7 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Employee8 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Employee9 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Employee10 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
.
.
.
.
.
.
.