At some point, you'll need to create lookup tables from data sources. Excel users often clump all entities together in each row. This is a…