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:E5does 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.