Hi everyone,
I'm just trying to get clarity on this because it seems that the only way to merge using Power Query is with unique values.
So basically I have 2 tables. The main table has a column with rows that contain a few duplicates. The column in the lookup table doesn't have any duplicates. Is there a way to return the same value to each duplicate in in the main table?
Any input would be greatly appreciated.
Thanks!
Bookmarks