I have a table in Google Sheets that lists products in rows and dependencies in columns. Most product depend on only a few things so there are a lot of columns showing extraneous information which makes it look at. I can hide all the columns not relevant to a given product, as well as all the rows not associated with the product (there are multiple rows for a product representing different pipeline stages).
However, if I want to switch products, I have to manually unhide everything and then manually rehide stuff for the new product. I thought I could use a filter view to save the current view, but when I switch to a different filter it doesn't remember what was hidden for that view.
How can I have different preset settings which each remember which rows and columns were hidden for that setting?