I am trying to combine a new list with an existing data set. Many of the items on the list are alias' for the same account. I will be importing data from different sources that will continue to use these names/alias'. I need to create a Master List where the Parent name does not duplicate and can be used as a lookup table in Power BI. On the workbook attached is an example of an Existing Master and the New accounts to add.
Also, is there a way to highlight Accounts in the same column that are very similar but not exact? Acura Nissan, Acura Toyota, The Acura Nissan
Please let me know if you need more information. Any help of direction is appreciated. Thank you.
Bookmarks