I got one list with some values that might be duplicated, however, column associated with it is different, like: ( possible values are only 4 DRY,RFG,FRZ,CHOC )
Every time I have duplicates, as the first 2 rows, I would like to apply and specific value, in this specific example the value would be "RFG" ...how can I do it ?
This would be the rules :
1. Unique values keep their 2nd column value
2. Duplicates that contain RFG should be consolidated as RFG
3. Duplicates that contain FRZ should be consolidated as FRZ
4. Duplicates that contain CHOC should be consolidated as RFG