Hi everyone,
I have a customer list that features two columns. Column A contains Customer Numbers. This column can contain duplicates. Column B contains product info. For the duplicate customer numbers, the product information in column B can be different so I want to concatenate the product info into one cell for all duplicate customer numbers. For non-duplicates, I want to leave the product listed as is. I can't figure out a formula to achieve this result. Does anyone have any suggestions?
Example is attached.
Bookmarks