Extract info into a string

[Gixxer Lad]

Hello all,
If possible I would like a formula to go into cell N2 to make a string of all the players that have scored in the Row 2 to look like it does in the attached sheet.
Many thanks in advance.

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Player 1	Goals 1	Player 2	Goals 2	Player 3	Goals 3	Player 4	Goals 4	Player 5	Goals 5	Player 6	Goals 6
2	John	2	Dean		Harry	3	Jerry		Bob		Bill	3		John 2, Harry 3, Bill 3
3
Sheet1

 

[Peter_SSs]

Like this?

Gixxer Lad_1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Player 1	Goals 1	Player 2	Goals 2	Player 3	Goals 3	Player 4	Goals 4	Player 5	Goals 5	Player 6	Goals 6
2	John	2	Dean		Harry	3	Jerry		Bob		Bill	3		John 2, Harry 3, Bill 3
Sheet1

Cell Formulas
Range	Formula
N2	N2	=TEXTJOIN(", ",,IF(ISNUMBER(B2:L2),A2:K2&" "&B2:L2,""))

 

[Gixxer Lad]

How do these things look so easy when you have the solution
Thank you Peter.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.