TEXTJOIN 2 columns over multiple rows

[Allen_Mead]

Hi, I would like to join 2 columns together using 'text join' and would therefore be as follows:

Bob, 0
Fred, 1
George, 2
etc., etc.,

Column A has a name, column B has a number and I would like to separate them with a comma. I can do single rows as follows:

=TEXTJOIN(", ", TRUE, A4:B4)

But having trouble with multiple rows, I can do it but, I can't get it to show each name on a new line in the single cell, it's just one continuous line of text with a comma between every entry such as my effort below:

Bob, 0, Fred, 1, George, 2,

=TEXTJOIN(", ", TRUE, A2:B13)

 

[Fluff]

How about

=SUBSTITUTE(TEXTJOIN({", ","|"},,A2:B13),"|",CHAR(10))

 

[Allen_Mead]

How about

=SUBSTITUTE(TEXTJOIN({", ","|"},,A2:B13),"|",CHAR(10))

Absolutely spot on! Perfect and thank you.

 

[Fluff]

You're welcome & thanks for the feedback.