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?
Bookmarks