Matching a single cell to multiple cells

I am trying to match a single cell to other cells sharing the same value. In the simplified example below, the idea is to show all pet stores that also contain the specified pet. The fist table demonstrates the starting data, and the second table illustrates the desired output. In the case of the actual dataset there are hundreds of "pets" and dozens of "stores". Thanks.

Input:

cat	pet store 1
dog	pet store 1
hamster	pet store 1
cat	pet store 2
dog	pet store 2
parrot	pet store 2
dog	pet store 3
hamster	pet store 3

Output:

cat	pet store 1	pet store 2
dog	pet store 1	pet store 2, pet store 3
hamster	pet store 1	pet store 3
cat	pet store 2	pet store 1
dog	pet store 2	pet store 1, pet store 3
parrot	pet store 2
dog	pet store 3	pet store 1, pet store 2
hamster	pet store 3	pet store 1

Please Login or Register  to view this content.