You said:
Anyway first select your product ID's and move them and, from data ribbon tab, remove duplicates.

I must not be understanding this. If I remove the duplicate product IDs in sheet1, it removes the associated code.
What am I missing?

Thanks for your help!
Karen