Map Table 1 to Table 2 and Create New Where None Exists

There are two lists. List 1 (403 rows) is the master list and existing names must NOT be changed List 2 (980 rows) contains rows of similar items to List 1. It has duplicates. Clean up as needed so there are no duplicates. The object is to map the lists so that every instance of List 2 is represented in List 1. There are more items in List2 than List1 so new categories need to be created in List 1. Most of List 2 can be already mapped to List 1 using either: LIST2.CATEGORY+[login to view URL] = LIST1.CAT_NAME+LIST1.PARENT_NAME LIST2.CATEGORY_NAME+LIST2.PARENT= LIST1.CAT_NAME+LIST1.PARENT_NAME Where there are no existing mappings, create a new row in LIST1. New Row Logic: 1. Create a new row where neither of the two above mappings work. 2. If the new row is a brand new category, then add a top level category after the last number used for top level category in List 1 (List 1 top level categories are all 2 digits). 3. If a new child category needs to be created in List 1, then start the child category from the number 10 (i.e. parent 45, child starts at 4510, NOT 4501). 4. Use the List 2 PARENT AND CATEGORY NAME for both parent and child field in List 1. Document is attached. Please review prior to bidding. Please feel free to send questions. Contents of List 1 and List 2 List 1 cat_id cat_name cat_parent_id cat_parent_name List 2 PARENT CATEGORY CATEGORY_NAME ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platform Windows - MS Excel VB preferred