Excel How To: Reverse Ingredient List

[SzczerbiakManiac]

Originally Posted by Moonliner

How are they listed in the table:

Like this:
A1 French Toast
A2 Eggs
A3 Cinnamon
A4 Butter

A6 Pancakes
A7 Eggs
A8 Flour

It's essentially a plain list, but each item is listed in its own cell. Each recipe/ingredient list is separated by an empty row. I can fiddle with the layout of that would help. E.g., either of these would be easy to accomplish with a quick bunch of cut & pastes:
A1 French Toast
A2 Eggs
A3 Cinnamon
A4 Butter

B1 Pancakes
B2 Eggs
B3 Flour
_____________________________

A1 French Toast
B2 Eggs
B3 Cinnamon
B4 Butter

A6 Pancakes
B7 Eggs
B8 Flour