This is how my main data sheet looks like
And for any item that has customization, for e.g. - ORGANIC, I want to extract/copy just those data, the meal name & total units to another sheet. And then transpose them.
Partial answer to my question:
However this only brings up 1 row, not all matches.
Using that with FILTER, same result:
Works but now I have no clue how to drag this down. To find other values.
Here is my sample sheet:https://docs.google.com/spreadsheets/d/1cAGa-Mc6KQjrTjwe8OM58wHbABDxI4toEbYOIs8_9VE/edit?usp=sharing