Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table
column 1 column2
John Blue
Many Red
John Red
Bill Blue
Mary Blue
Mary Pink
I want to know all the people in colum1 that have the same values in column2. Here, people must have red AND blue
Result
John Red Blue
Mary Red Blue
@jcpreta can you check
column 1 column2
John Blue
Many Red or Mary ?
John Red
Bill Blue
Mary Blue
Mary Pink
solution in script ?