Consolidation of Data

[maeyks]

I use excel to input certain recipes. Let's say we have recipe a, b, c and d.

From each recipe i have different types of ingredients. Lets say we have 5, 7, 10, 8 ingredients for recipes a to d, respectively.

There are some ingredients that are common on some recipes (a to d).

I used this 4 recipes for the months of july to september. Definitely there will be a difference on some of the ingredients per recipe, on a monthly basis, since i have different quantity requirements for all 4 recipes.

My question is:

How can i consolidate all the ingredients from the 4 recipes on a monthly basis?

I do hope someone can help me

 

[PCL]

Prepare data in column with date, ingredients, recipe ref, quantity and use Pivot Table.
Send your file if you want more details