Hi,
I have a list of products.
Column A = Unique SKUS
Column D = Product Family
On a new column, I want to figure out a formula where I could get all the Sku of the same family separated by |
So the result would be that all of the families are grouped together
I have 1000+ products to sort out.
Can someone please help?
I tried:
a version of Concat all that I found =ConcatAll(IF(IF($D$3:$D$1099=D3,$A$2:$A$1099,"")=A2,"",IF($C$3:$D$1099=C2,$A$2:$A$1099,"")),"|") but I just got a name error. I don't know how to make this work can anyone help?
I've attached the data I'm working with
Bookmarks