List all entries for the multiple criteria from same column

Hello,

I have a large data set and I was wondering how to achieve filtering on multiple criteria (AND instead of OR as is the default filtering)

I have 2 columns similar in structure to the below.

I am trying to figure how to identify the Locations (column 1) based on having all entries matched for column 2 (Item)

Ie, if I wanted to find all locations (list) that have "Rock" AND "Paper" listed on column 2:

in the below example it would:

Paris

Istanbul

How can I do that? I have tried a pivot, but it seems I cannot make it work

Also, if I wanted to have a Column three and apply the same as above but also return the Locations that have both an all for the columns 2 criteria and at least they match a criterion from column 3, how could I do it?

ie Item = Rock AND Paper and Degrees should include 120

Result = Paris (in a list to account for multiple cases of locations matching these criteria)