I have been working on this issue for several hours now. I am essentially trying to normalize data based on item numbers and their description. I would like to have one unique description description for every unique item number but currently the descriptions have small differences in them, complicating things. I was using pivot tables to see the different descriptions, then going back to the original worksheet and changing the description there but it has been taking a while so I have been playing around with IF statement with no such luck. It does not have to be a particular description, so long as it is uniform throughout. Please see example below. Any help would be greatly appreciated! Thank you!
<tbody>
</tbody>
Item | Description | Final Description |
1 | Apple | Apple |
1 | apples | Apple |
1 | Apple - Fruit | Apple |
2 | Grape | Grape |
2 | Grape | Grape |
3 | OJ | OJ |
3 | OJ | OJ |
3 | Orange Juice | OJ |
<tbody>
</tbody>