Power Query
ID |
Name |
Count |
1 |
Simon |
2 |
7 |
Simon |
1 |
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Grp = Table.Group(Source, {"ID ", "Name"}, {{"Count", each Table.RowCount(_), type number}}),
KD = let columnNames = {"Name"}, addCount = Table.Group(Grp, columnNames, {{"Count.1", Table.RowCount, type number}}), selectDuplicates = Table.SelectRows(addCount, each [Count.1] > 1), removeCount = Table.RemoveColumns(selectDuplicates, "Count.1") in Table.Join(Grp, columnNames, removeCount, columnNames, JoinKind.Inner)
in
KD
Bookmarks