How do I convert values from a column into rows without losing data in existing rows below? For example, I have data in this format:

A | B | C | 1 | Apples| Berries | Cakes | 2 | Pies | Crusts | Nuts |

I need the following:

A. 1| Apples 2| Berries 3| Cakes 1| Pies 2| Crusts 3| Nuts