How to create dynamic lookup table

Hi 

I have a data table (Data) with duplicate company name and each month also potentially has new company names.

I want to create a dynamic Lookup table from the data table and relate it back to the Company Table, so that it dynamically removes duplicates and also ads any new companies to the lookup table. I have seen a video from either DNA Enterprises, Curbal or Two guys in a cube that had a process to create this outcome.

Company 1:N Data

with new companies that appears in the data table each quarter added dynamically to the lookup table and duplicates removed such that Company is a lookup table.

Any ideas how I might achieve this? 

Thanks in advance

John