Hello, I am trying to do the following, but I can't seem to come up with a
forumla.

Let say I have a table below

Group
Name A B C
Pete N Y N
Jane Y N Y
John N Y Y

is it possible to create a new sheet to to show the "Y" values?

Group Name
A Jane
B Pete
B John
C Jane
C John

thanks,

PJS