Column Consolidation

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

Johnny Banana

By: J

Leave a Reply

Your email address will not be published. Required fields are marked *