Power Query Challenge - Creating a Merge Duplicates Alert

XLOOKUP v Power Query v Power Pivot in Excel

When combining tables in Excel there are several options.

Here I show you XLOOKUP, Power Query Merge and a Power Pivot relationship.

https://www.youtube.com/watch?v=KdF-OQ8G5FY&t=0s

A twist to turn Keep Duplicates into Keep Unique in #PowerQuery

In Power Query Editor, there is a button of “Keep Duplicates” in the ribbon. It’s located under Keep Rows in the section of Reduce Rows in the Home tab of the ribbon.

https://wmfexcel.com/2022/04/07/a-twist-to-turn-keep-duplicates-into-keep-unique-in-powerquery/