# Matching a single cell to multiple cells

1. ## 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

2. ## Re: Matching a single cell to multiple cells

``Please Login or Register  to view this content.``

3. ## Re: Matching a single cell to multiple cells

A possible solution is a Pivot Table

4. ## Re: Matching a single cell to multiple cells

Pl see the attached file.

There are currently 1 users browsing this thread. (0 members and 1 guests)