I have a Recipe with percent of ingredients master data in a sheet like this
example sheet but I have huge list in actual file.
Ingredients for Coffee Tea Juice Fruit salad

Nescafe Powder 10 10
Bru coffee Powder 10 10
Sugar 20 20 35 30
Apple 50 50
Water 50 50 5 5
Cream 10 10 10 15
Total 100 100 100 100

I would like to from the above data using Excel functions. I want know how
to make the Batch list in a new sheet so that I get a recipe in a compact
list. My Idea is to get the a list with its ingredients for Coffee or Tea
without the Blank row even there is blank cell in the values.