let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Invoice No.", type text}, {"Sales", type text}, {"quantity", Int64.Type}, {"rate", type number}, {"Total", type number}}),
#"Filled Down" = Table.FillDown(#"Changed Type",{"Invoice No."}),
#"Added Custom" = Table.AddColumn(#"Filled Down", "Customer", each if Text.Contains([Sales],"Customer") then [Sales] else null),
#"Filled Down1" = Table.FillDown(#"Added Custom",{"Customer"}),
#"Reordered Columns" = Table.ReorderColumns(#"Filled Down1",{"Invoice No.", "Customer", "Sales", "quantity", "rate", "Total"}),
#"Filtered Rows" = Table.SelectRows(#"Reordered Columns", each not Text.StartsWith([Sales], "Customer"))
in
#"Filtered Rows"