Here is what I'm working with and what it should look like:
When a category is checked on the right side of the image, cell B12 should concatenate those cells together and separate each entry with a comma. I think I'm pretty good with formulas but this is a little beyond my skill level and nothing I'm doing is working.
You may try:
=join(", ",filter({D:D;F:F},{E:E;G:G}))