Finding combinations on values within one column, and per group

[Roche]

Hi everyone

I need some help with combinations.  The data consists of groups for which different values are assigned per group.  I need each combination (or pairs of combinations) that can be created among the unique values in each group.  Can someone perhaps help me?  Attached is an example of what the data looks like and what I need the outcome to be. (the outcome can also be in set format, since then I can just clean and parse to get the columns)

Thank you

[Christina_H · Accepted solution]

Join the data to itself by ID to generate all combinations, then filter out duplicates

[atcodedog05]

Nicely done @Christina_H 😀👍

[Roche]

Thank you Christina, this is a very handy trick!