Spreadsheet: 793682d1661637308-how-to-repeatedly-add-charges-from-one-row-to-another-within-a-block-of-rows-sample-workbook
Sheet: Sheet1

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