Hi. I have a nubie question that I need help with:
I am trying to concatenate text from ONE cell with text from MULTIPLE cells (a column with many values) to create a new list.
For Example:
Cell A1= John is friends with
Cell B1= Jimmy
Cell B2= Tom
Cell B3= Jane
I need a formula that takes the values from A1 and combines (concatenates) it with B1 in one cell, then with B2 in another cell, then with B3 in another cell (but all in one column) - like this:
C1 value = John is friends with Jimmy
C2 value = John is friends with Tom
C3 value = John is friends with Jane
...creating a new column that is linked to the original 2 columns.
Basically, I want a one-to-many merge. Can anyone help?
I am trying to concatenate text from ONE cell with text from MULTIPLE cells (a column with many values) to create a new list.
For Example:
Cell A1= John is friends with
Cell B1= Jimmy
Cell B2= Tom
Cell B3= Jane
I need a formula that takes the values from A1 and combines (concatenates) it with B1 in one cell, then with B2 in another cell, then with B3 in another cell (but all in one column) - like this:
C1 value = John is friends with Jimmy
C2 value = John is friends with Tom
C3 value = John is friends with Jane
...creating a new column that is linked to the original 2 columns.
Basically, I want a one-to-many merge. Can anyone help?
