let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"SubCls_Name", type text}, {"Test_CD", type any}, {"Service_Description", type text}, {"Disc%", type number}, {"Invoice Count", Int64.Type}}),
#"Filled Down" = Table.FillDown(#"Changed Type",{"SubCls_Name", "Test_CD", "Service_Description"})
in
#"Filled Down"