Spreadsheet: 793652d1661612217-how-to-repeatedly-add-charges-from-one-row-to-another-within-a-block-of-rows-2022-08-27-oeldere-joseph222555-sample-workbook-2-
Sheet: Sheet1

 |  | Current Data |  |  |  |  |  |  | Expected Output
 | Bldg-Unit | Charge Code | Start Date | End Date | Amount | group |  |  | Bldg-Unit | Charge Code | Start Date | End Date | Amount
 | 111 | Garage Parking Charges | 2022-06-07 00:00:00 |  | 150 |  |  |  | 111 | Garage Parking Charges | 2022-06-07 00:00:00 |  | 150
 | 111 | Washer/Dryer | 2022-03-21 00:00:00 |  | 30 |  |  |  |  | Rent | 2022-03-21 00:00:00 |  | 2030
 | 111 | Rent | 2022-03-21 00:00:00 |  | 1800 |  |  |  |  | RUBS - Pest Control | 2022-03-21 00:00:00 |  | 15
 | 111 | First Floor | 2022-03-21 00:00:00 |  | 75 |  |  |  |  | RUBS - Valet Trash | 2022-03-21 00:00:00 |  | 35
 | 111 | RUBS - Pest Control | 2022-03-21 00:00:00 |  | 15 |  |  |  |  | Technology Fee | 2022-03-21 00:00:00 |  | 15
 | 111 | Pet Yard | 2022-03-21 00:00:00 |  | 125 |  |  |  |  | Cable Television Charges | 2022-03-21 00:00:00 |  | 90
 | 111 | RUBS - Valet Trash | 2022-03-21 00:00:00 |  | 35 |  |  |  |  |  |  | Total:
 | 111 | Technology Fee | 2022-03-21 00:00:00 |  | 15 |  |  |  | 112 | Technology Fee | 2022-04-01 00:00:00 |  | 15
 | 111 | Cable Television Charges | 2022-03-21 00:00:00 |  | 90 |  |  |  |  | RUBS - Valet Trash | 2022-04-01 00:00:00 |  | 35
 | 111 |  |  | Total: |  |  |  |  |  | RUBS - Pest Control | 2022-04-01 00:00:00 |  | 15
 | 112 | First Floor | 2022-04-01 00:00:00 |  | 75 |  |  |  |  | Rent | 2022-04-01 00:00:00 |  | 1405
 | 112 | Washer/Dryer | 2022-04-01 00:00:00 |  | 30 |  |  |  |  | Mitigated Risk | 2022-04-01 00:00:00 |  | 11.95
 | 112 | Technology Fee | 2022-04-01 00:00:00 |  | 15 |  |  |  |  | Cable Television Charges | 2022-04-01 00:00:00 |  | 90
 | 112 | RUBS - Valet Trash | 2022-04-01 00:00:00 |  | 35 |  |  |  |  |  |  | Total:
 | 112 | RUBS - Pest Control | 2022-04-01 00:00:00 |  | 15
 | 112 | Rent | 2022-04-01 00:00:00 |  | 1300
 | 112 | Mitigated Risk | 2022-04-01 00:00:00 |  | 11.95 |  |  |  |  | Charges to be Rolled into Rent
 | 112 | Cable Television Charges | 2022-04-01 00:00:00 |  | 90 |  |  |  |  | First Floor | RENT
 | 112 |  |  | Total: |  |  |  |  |  | Pet Yard | RENT
 | 113 | Mitigated Risk | 2022-04-29 00:00:00 |  | 11.95 |  |  |  |  | Washer/Dryer | RENT
 | 113 | Washer/Dryer | 2022-04-29 00:00:00 |  | 30
 | 113 | First Floor | 2022-04-29 00:00:00 |  | 75
 | 113 | Technology Fee | 2022-04-29 00:00:00 |  | 15
 | 113 | Pet Rent | 2022-04-29 00:00:00 |  | 20
 | 113 | Cable Television Charges | 2022-04-29 00:00:00 |  | 90
 | 113 | Pet Yard | 2022-04-29 00:00:00 |  | 125
 | 113 | Pool View | 2022-04-29 00:00:00 |  | 25
 | 113 | Rent | 2022-04-29 00:00:00 |  | 1750
 | 113 | RUBS - Pest Control | 2022-04-29 00:00:00 |  | 15
 | 113 | RUBS - Valet Trash | 2022-04-29 00:00:00 |  | 35
 | 113 |  |  | Total:
 | 114 | First Floor | 2022-05-20 00:00:00 |  | 75
 | 114 | Pet Yard | 2022-05-20 00:00:00 |  | 125
 | 114 | Pool View | 2022-05-20 00:00:00 |  | 25
 | 114 | Rent | 2022-05-20 00:00:00 |  | 1350
 | 114 | Technology Fee | 2022-05-20 00:00:00 |  | 15
 | 114 | RUBS - Pest Control | 2022-05-20 00:00:00 |  | 15
 | 114 | Washer/Dryer | 2022-05-20 00:00:00 |  | 30
 | 114 | RUBS - Valet Trash | 2022-05-20 00:00:00 |  | 35
 | 114 | Cable Television Charges | 2022-05-20 00:00:00 |  | 90
 | 114 | Mitigated Risk | 2022-05-01 00:00:00 |  | 11.95
 | 114 |  |  | Total:
 | 115 | RUBS - Pest Control | 2022-08-01 00:00:00 |  | 15
 | 115 | Rent | 2022-08-01 00:00:00 |  | 1360
 | 115 | First Floor | 2022-08-01 00:00:00 |  | 75
 | 115 | Washer/Dryer | 2022-08-01 00:00:00 |  | 30
 | 115 | Cable Television Charges | 2022-08-01 00:00:00 |  | 90
 | 115 | Technology Fee | 2022-08-01 00:00:00 |  | 15
 | 115 | RUBS - Valet Trash | 2022-08-01 00:00:00 |  | 35
 | 115 | Mitigated Risk | 2022-08-01 00:00:00 |  | 11.95
 |  |  |  | Total: