Look up data where value in column1 have the same combo of values in column2

[jcpreta]

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

[Taoufiq_Zarra]

@jcpreta  can you check

column 1 column2

John Blue

Many Red or Mary ?

John Red

Bill Blue

Mary Blue

Mary Pink

solution in script ?