Excel How To: Reverse Ingredient List

[SzczerbiakManiac]

A friend suggested this solution which suited me just fine:
Column A | Column B
Dish | Ingredient
French Toast | Eggs
French Toast | Bread
French Toast | Butter
Pancakes | Eggs
Pancakes | Flour
Pancakes | Sugar
Hollandaise Sauce | Eggs
Hollandaise Sauce | Butter
Hollandaise Sauce | Lemon

Then filter on the ingredient.

I pretty much taught myself how to use Excel, to there are huge gaps in my knowledge--including this probably obvious solution.

Thank you all for putting up with my ignorance.