Hi,

I'm trying to copy non-numerical values to a column from data in other columns. Here's an example...

I have fixed data in Columns B,C and D.

*Column B
Row 1: Red
Row 2: Green
Row 3: Blue
Row 4: Orange

*Column C
Row 1: Apples
Row 2: Oranges
Row 3: Bananas

*Column D
Row 1: To eat
Row 2: To bake
Row 3: To fry
Row 4: To rot

Now, In Column A I want to create the following dynamically...

Row 1: Red Apples
Row 2: Red Apples to eat
Row 3: Red Apples to bake
Row 4:Red Apples to fry
Row 5:Red Apples to rot
Row 6:Red Oranges
Row 7:Red Oranges to eat
Row 8:Red Oranges to bake
...
Row X:Green Apples
Row X:Green Apples to eat

I was trying to use the "SUBSTITUTE" formula, however, I didnt have any success. Does anyone know which formula to use to create this list in Column A?