Combine Cells when same Value in another column

[Dani_LobP]

Hi,

I'm struggling to find a way to make some textjoin alike formula with IF condition and also "unique" too in order to combine results that share same value.

I have something as per below example:

ID	Type
Name1	Type1
Name1	Type2
Name2	Type2
Name3	Type1
Name4	Type1
Name4	Type1
Name4	Type1

And the result I would like to obtain, is to display for each Name, what combinations they have..

Name1 should display Type1-Type2
Name2 should display Type2
Name3 should display Type1
Name4 should display Type1-Type1

=TEXTJOIN("-",TRUE,SORT(UNIQUE(IF([ID]=[@[ID]],[Type],""))))

Ofc if using Unique, it wont allow repetition as Type1-Type1 for example, but unsure of how other option i can do so it allows at least 1 duplication...

Hope it makes sense the explanation and the goal.

thanks in advance!

 

[Fluff]

Glad we could help & thanks for the feedback.