title: Best way to filter both Vertically and Horizontally?
body: <p>I have a large data set which contains users and the groups they belong too (they can be in many groups). I currently have 265 users and 94 groups. I'd like to find the best way to display this information. Right now I have a very large spreedsheet that shows me this information, but I can only filter the groups (column) to find out which users are in that group. Ideally, It would be great to also be able to filter the users to find all the groups on user belongs too.</p>
  
  <p>Here's a demo of what my sheet looks like:
  <img src="https://i.stack.imgur.com/q4tQT.png" alt="enter image description here"></p>
  
  <p>Transposing won't work with 265 users and I'd rather not have two spreadsheets with the same information. Any ideas?
  Thanks.</p>