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?
Bookmarks