Filter flattened Google Sheets table and replace values-CodePudding

Home > OS > Filter flattened Google Sheets table and replace values

Filter flattened Google Sheets table and replace values

Time：12-09

I'm generating Table 2 out of Table 1

with following formula:

={flatten({A3:A,A3:A}),arrayformula(flatten({if(A3:A<>"",B$2,),if(A3:A<>"",C$2,)})),flatten({B3:C})}

How can convert the 1s to trueand 0s to false and set a filter to show only the rows with true in the same formula?

So, the desired outcome would be: