Find populated cells in list of products and their ingredients and weights

Hi all,

We are working with a long list of food products and their corresponding ingredients by weight. What we would like to make is a table that when a certain product is typed in, will populate the fields with the corresponding ingredients (e.g. butter), amount of each ingredient (e.g. 0.6) and unit of each ingredient (e.g. kg).

The format of our sheet has the product names on the y-axis and the ingredient list and unit list along the x-axis.

The difficulty is that out of the 500 or so ingredients, each product will only have a fraction of that number. How do we create a formula that only picks up the populated cells for each ingredient that corresponds to each product? And how do we transfer that information into an easily digestible table?

Any ideas are much appreciated!