I want to filter an array returned by a filter to remove blank columns. Here is a picture of an example sheet:
I am filtering the large table by the rows that are of type b
. I am retrieving the columns via the key on the left. This is a very basic example of my sheet, where there may be many rows of type b
, but there are only two columns of type b
. The column headers may be the same as other headers, and they may change based on the key.
I understand how to perform a two-dimensional filter by putting the results of one filter inside of another. However, I cannot figure out how to filter the result of a filter by itself.
If I have a formula that returns 5 columns and 3 rows. How do I say: "I want to filter out all columns that are blank". This would normally be something like Filter(A1:E5, A:E <> "")
where A1:E5
does not actually exist on the spreadsheet, but is instead an array in a formula (Not sure what that is technically called).
Hopefully this is better explained than my last question, if it is not, please let me know.