I am a basketball official needing to make a list of scheded games and the
officials assigned to them. For any game we may use from two to four
assigned officials filling any one of the four named officials positions. I
have so far tried working with a spread sheet which includes four columns -
one each for each of the four positions. I am running into problems using
filtering because as soon as I filter the first officials column for a
certain offiials name, it disrupts me from filtering the 2nd, 3rd and 4th
officials columns for the same officials name.

How can I create and then filter (for eventual printing) a single spread
sheet where my goal is to list only those games for a specific person
regardless of the position they are assigned?