Remove duplicates in Excel Power Query

preview_player
Показать описание
00:00 Remove duplicates via Power Query in Excel
00:10 Duplicate where multiple cells are the same
00:17 Load the duplicates table into Power Query
00:27 Remove duplicate rows button in Power Query
00:33 Remove duplicates where whole row (all columns) are a duplicate
01:10 Remove duplicates in a single column
01:30 Specify to Power Query what indicates a duplicate

How to remove duplicated rows from a table using Excel's Power Query including how to remove a row when multiple columns are the same.
Рекомендации по теме