Hi
I have 1100+ products but due to the spread sheet listing each product variation as a separate row there are 120,000+ rows. I need to run a quick Macro that takes the style # or product name and compares all the other columns and deletes any duplicate values leaving all unique values separated with "|" (no space necessary).
Attached is a sample... with the demonstrated result on sheet two.
Sample Data.xlsx
Thank you for your help in advance!
Bookmarks