Data Normalization

[randrze2]

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!

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Description[/TD]
[TD]Final Description[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Apple[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]apples[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Apple - Fruit[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Grape[/TD]
[TD]Grape[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Grape[/TD]
[TD]Grape[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]OJ[/TD]
[TD]OJ[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]OJ[/TD]
[TD]OJ[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Orange Juice[/TD]
[TD]OJ[/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

Welcome to MrExcel.

In C2 copied down:

=VLOOKUP(A2,A:B,2,FALSE)

 

[randrze2]

Perfect. Thanks much!