Hello - I have a server inventory list that I'm trying to organize for
end users based on what group the servers belong in.  Some servers
belong exclusively in our "Staging 1" environment, some servers belong
exclusively in our "Staging 2" environment, and some are shared
between the two.  I have a column that is named, "Environment" and
right now I have assigned the exclusive servers to their appropriate
groups however the ones that are shared need to be categorized by
something like, "Staging 1 and 2."  The problem I'm facing is that I
want someone using the spreadsheet to be able to filter based on no
more than the two environments - Staging 1 or Staging 2.  If someone
filters to view either one of those groups then he or she should see
the servers in the "Staging 1 and 2" group as well because they're
shared across both.

Does anyone have a solution?  Thanks in advance!

Charlie