I am trying to set this up. I have a Table with a list of companies, years, and list links where I got them from. I have another table with the list links, list names and years. I am trying to get the companies to merge into one source with the list ...

I have something like the pic below where I have 50-250 companies in multiple yearly lists. Any single company can only be in a list one. But a single company can be in any set of lists and years. I want to merge the companies in the yearly lists int...