let
Source = Excel.CurrentWorkbook(){[Name="TBLREADINGS"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Reading Date", type datetime}, {"Completion time", type datetime}, {"Email", type text}, {"Name", type text}, {"Region", type text}, {"Select Site", type text}, {"Select Site2", type text}, {"Select Site3", type text}, {"Select Site4", type text}, {"Site Name", type text}, {"Select Meter", type text}, {"Select Meter2", type any}, {"Select Meter3", type text}, {"Select Meter4", type any}, {"Select Meter5", type text}, {"Select Meter6", type text}, {"Select Meter7", type text}, {"Select Meter8", type any}, {"Select Meter9", type text}, {"Select Meter10", type any}, {"Select Meter11", type text}, {"Select Meter12", type text}, {"Select Meter13", type text}, {"Select Meter14", type text}, {"Select Meter15", type text}, {"Select Meter16", type text}, {"Select Meter17", type text}, {"Select Meter18", type any}, {"Select Meter19", type text}, {"Select Meter20", type text}, {"Select Meter21", type text}, {"Select Meter22", type text}, {"Select Meter23", type text}, {"Select Meter24", type text}, {"Select Meter25", type any}, {"Select Meter26", type text}, {"Select Meter27", type any}, {"Select Meter28", type any}, {"Select Meter29", type text}, {"Select Meter30", type text}, {"Select Meter31", type any}, {"Meter Name ", type text}, {"Utility Type", type text}, {"Month", type text}, {"Jan", type number}, {"Feb", type number}, {"Mar", type number}, {"Apr", type number}, {"May", type any}, {"Jun", type any}, {"Jul", type any}, {"Aug", type any}, {"Sep", type any}, {"Oct", type any}, {"Nov", type any}, {"Dec", type any}, {"Comments ", type text}, {"Photots", type any}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Month", "Select Meter", "Select Meter2", "Select Meter3", "Select Meter4", "Select Meter5", "Select Meter6", "Select Meter7", "Select Meter8", "Select Meter9", "Select Meter10", "Select Meter11", "Select Meter12", "Select Meter13", "Select Meter14", "Select Meter15", "Select Meter16", "Select Meter17", "Select Meter18", "Select Meter19", "Select Meter20", "Select Meter21", "Select Meter22", "Select Meter23", "Select Meter24", "Select Meter25", "Select Meter26", "Select Meter27", "Select Meter28", "Select Meter29", "Select Meter30", "Select Meter31", "Select Site", "Select Site2", "Select Site3", "Select Site4", "ID", "Reading Date", "Completion time", "Email", "Name"}),
#"Grouped Rows" = Table.Group(#"Removed Columns", {"Region", "Site Name", "Meter Name ", "Utility Type"}, {{"Jan", each List.Sum([Jan]), type nullable number}, {"Feb", each List.Sum([Feb]), type nullable number}, {"Mar", each List.Sum([Mar]), type nullable number}, {"Apr", each List.Sum([Apr]), type nullable number}, {"May", each List.Sum([May]), type any}, {"Jun", each List.Sum([Jun]), type any}, {"Jul", each List.Sum([Jul]), type any}, {"Aug", each List.Sum([Aug]), type any}, {"Sep", each List.Sum([Sep]), type any}, {"Oct", each List.Sum([Oct]), type any}, {"Nov", each List.Sum([Nov]), type any}, {"Dec", each List.Sum([Dec]), type any}})
in
#"Grouped Rows"