How to list Months between two dates?

Here is one way

Create a lot of columns

In E1 enter January 2021. I drag-filled to the right to fill in the headers of the other columns

E2 =IF($A2≠"",IF(AND($C2≤E$1,$D2≥E$1),$B2,""),"")

Drag fill to all the rest of the rows and columns

You may have to adjust the formula (commas vs semicolons) to match your region. The dates in my table are MM/DD/YYYY.

Each column has the bill for that month but not the exact date in the month.

Having it all in one big table makes it easier to chart the data. But if you want to view the data in other tables, you can do that with formulas and you can hide the columns in this table. The wide table is not the best for viewing the data and certainly not good for printing it unless you hide columns and show only a year or so at a time.

Enter it into a blank row of the table.

Copy/paste the table to make a new table that is set up with the same columns

Delete columns B,C,D.

Delete all the data

Column A should have each category (Energy, Water, etc.) listed one time

Formula in cell B2 =SUMIF(Table 1::$A,$A,Table1::E) this assumes the other table is named Table 1

Drag-fill or copy/paste it to the rest of the columns and rows.

This should aggregate all "Energy" rows from Table 1 into one "Energy" row in this new table. Same for the other categories.

Just to be sure the two tables match up date-wise if you ever make a change to the dates in row 1 of Table 1, you might also want do this:

Put into cell B1 the formula =Table 1::E1

Drag-fill or copy/paste it to the rest of the row