Spreadsheet: 807378d1669879121-excel-formula-to-convert-raw-data-to-my-desire-format-actual-data-with-actual-result
Sheet: Final result

 | Month | ADW Income Current Month | ADW Worked Days Current Month | Average Daily Rate
Employee1 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
Employee1 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
Employee1 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
Employee1 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
Employee1 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
Employee1 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
Employee1 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
Employee1 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
Employee1 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
Employee1 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
Employee1 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
Employee1 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
Employee1 | 2022-11-01 00:00:00 | 0 | 0 | 0
Employee1 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee2 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee3 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee4 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee5 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee6 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee7 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee8 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee9 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
Employee10 | 2021-11-01 00:00:00 | 30112.35 | 19 | 1584.86
 | 2021-12-01 00:00:00 | 36747.49 | 24 | 1531.15
 | 2022-01-01 00:00:00 | 38899.74 | 22 | 1768.17
 | 2022-02-01 00:00:00 | 34905.43 | 20 | 1745.27
 | 2022-03-01 00:00:00 | 25000 | 23 | 1086.96
 | 2022-04-01 00:00:00 | 34314.78 | 21 | 1634.04
 | 2022-05-01 00:00:00 | 38442.41 | 24 | 1601.77
 | 2022-06-01 00:00:00 | 29759.62 | 18 | 1653.31
 | 2022-07-01 00:00:00 | 43296.94 | 21 | 2061.76
 | 2022-08-01 00:00:00 | 43964.97 | 23 | 1911.52
 | 2022-09-01 00:00:00 | 40559.08 | 22 | 1843.59
 | 2022-10-01 00:00:00 | 22165.05 | 23 | 963.7
 | 2022-11-01 00:00:00 | 0 | 0 | 0
 | 2022-12-01 00:00:00 | 0 | 0 | 0
.
.
.
.
.
.
.