Conditional String Concatenation

[Solentos]

Hello,

I'm trying to concatenate a column of strings based on whether or not the players were active for each game. I attached the file below. You can ignore what is in H2 already.

In essence, in H2 (corresponding to the active players for game 1), the string would be "LeBron JamesJeff GreenTristan Thompson...Rodney HoodCedi Osman". And it would exclude Clarkson, Calderon, etc. And then the same thing for games 2-4.

I figure the solution may contain a mix of vlookup(), concat(), and/or if() functions, but I'm not exactly sure how to set this up. Any ideas on how to do this?

[Bo_Ry]

If you have Excel 365 you can use
=TEXTJOIN(,,INDEX(REPT($B$2:$B$53,($A$2:$A$53=$G2)*($C$2:$C$53="A")*($D$2:$D$53="A")),))

to Concatene all text that matches criteria but
Excel 2016 don't have this function.
You have to display 1 cell for 1 Name and concatenate them

H2
=I2&J2&K2&L2&M2&N2&O2&P2&Q2

I2:Q5
=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($A$2:$A$53)/($A$2:$A$53=$G2)/($C$2:$C$53="A")/($D$2:$D$53="A"),COLUMNS($I2:I2))),"")