How to rather keep the duplicate entries in Excel's Power Query based on a duplicate being a item where multiple columns are the same. ------------------------------------------------------------------------------------------------------------------------------------------------------ ✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s... 🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e... 🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex... 🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/ ------------------------------------------------------------------------------------------------------------------------------------------------------ ⏲Time Stamps 00:00 Keeping the duplicate with Excel's Power Query 00:25 Keep duplicates rather than remove duplicates 00:35 Specify what columns must match to be considered a duplicate 01:04 What keep duplicates would look like with only one column