let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"Head1"}, {{"Count", each _, type table [Head1=number, Head2=text, Head3=text, Head4=text, Head5=text, Head6=text, Head7=text, Head8=text, Head9=text, Head10=text, Head11=text, Head12=text, Head13=text, Head14=text, Head15=text, Head16=text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Ind",1,1)),
#"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
#"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"Head1", "Head2", "Head3", "Head4", "Head5", "Head6", "Head7", "Head8", "Head9", "Head10", "Head11", "Head12", "Head13", "Head14", "Head15", "Head16", "Ind"}, {"Head1", "Head2", "Head3", "Head4", "Head5", "Head6", "Head7", "Head8", "Head9", "Head10", "Head11", "Head12", "Head13", "Head14", "Head15", "Head16", "Ind"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded Custom", each ([Ind] <> 1))
in
#"Filtered Rows"
Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "
Bookmarks