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?
How to save a view in Google Sheets?
google spreadsheets