Match based on one column only

[kalliohd]

Hello!

I have a situation that I need to force a match.  Column A has a list of UPCs and column B is the name of the item.  The problem I am having is that some of the names of items are not full descriptions, resulting in multiple records for some UPCs. How can I make them match to be only one record with 15000.00 value?

UPC               Name           Total Dollar Value

123456789     Product 1     5000.00

123456789     Product_1    7000.00

123456789     Prod 1          3000.00

[alexnajm · Accepted solution]

You can use a Summarize tool - Group By [UPC], take the First of [Name], and Sum [Total Dollar Value]. Or if you want to see all the [Name] values, Concatenate can work too

[kalliohd]

Thank you!  Using summarize and taking the first of the Name worked perfectly!