Replacing newline characters in Column A with contents from Column B

[brvnbld]

I have two Columns, The first column has 5-10 paragraphs of text. Second Column has some data separated by commas. I wanted to merge these two data in the column into a new column. The Idea I had was to replace all the newline character in the first column with data from the second column until a comma. How to do this using formulas or VBA scripts?

 

[brvnbld]

I have two Columns, The first row in column A has 5-10 paragraphs of text. First row in column B has some data separated by commas. I wanted to merge these two data in the columns into a new column. I want to Merge the data from the second column into the first column data after every newline character. And the data in the second column are separated by newline characters. How to do this using formulas or VBA scripts?

For Example

A	B	C
AValue1\nAValue2\nAValue3	Bvalue1\nBvalue2	AValue1\nBvalue1\nAValue2\nBvalue2\nAValue3

The \n representing a newline character. if number of Values in B exceeds that of the Values in A, they can just be inserted one after another.