For my pizza hobby I keep track of the pizzas I like to make and the ingredients in them. I have a good sheet with the following data.
I would like to make a view of the same data where I can see the specific pizzas and ingredients I'm going to make today (filtering by the 2nd row "Select"). The end result would look something like the list below.
I have tried to use both a Pivot table and the Query function. Generally looking for how I can implement logic like: Select value_in_row_1, (sub select for ingredients) where value_in_row_2 is TRUE. Looking for any pointers or tips on what I can try.
Best Answer