So, I have been tasked with a reconciliation project in which I have to reconcile the Financial Managers from Screenshot 2 to update the Managers from Screenshot 1, in order to add the corresponding fund category (shown in screenshot 1). The current list (Screenshot 1) will have additional funds & will also be missing funds. If it is missing funds, they were either closed or deactivated and if there are additional funds, my manager will manually assign them herself.
I really think I am overthinking this but I tried to reconcile via Power Query but I'm not able to fully reconcile the data per my manager's instructions. What would be the proper way to reconcile these two datasets?
Screenshot 1
Screenshot 2
I really think I am overthinking this but I tried to reconcile via Power Query but I'm not able to fully reconcile the data per my manager's instructions. What would be the proper way to reconcile these two datasets?
Screenshot 1
Screenshot 2