I have two columns, one with a name and one with an item. There are sometimes multiple names for the same item and multiple names with different items. I am trying to consolidate the list so I only have one name for each distinct item.
Name Item Name Solution Item Solution
Johnny Apple Johnny Apple
Johnny Apple Johnny Banana
Mark Orange Mark Orange
Mark Banana Mark Banana