Numbers: Consolidate text from several cells into one

[Just-me]

Hello and thanks for reading this.
Using Numbers version 10.0 on a 2019 MBP with Catalina.
I'm wondering if what I want (following) is doable in Numbers.
Attached an example of what I need: row 1, columns C:J have titles (all times, instrumental etc.). C2:J22 have cells with "x" in them.
I need a formula/function to write in column B ("Grouping) a consolidation of all the titles corresponding to the "x"s in the row.
IE row 2 has "x"s in D, E and G, so B2 is "Daily Instrumental 2 long".
Thanks in advance for any help.
JM

 

[sracer]

Here's the beginning of a formula that gives you an idea on how to do what you want to do:
(this formula would go in cell B2)

=CONCATENATE(IF(NOT(ISBLANK(C2)),C1,""),IF(NOT(ISBLANK(D2)),D1,""),IF(NOT(ISBLANK(E2)),E1,""))

The basic approach is to check if a cell is blank, if it isn't, use the header and concatenate them. It only processes columns C thru E (you can build out the rest). The other limitation is that it doesn't add spaces between the words but you can modify this formula to do it, or "cheat" and add a trailing space to each of the headers.

I'm sure there are easier more elegant ways to do it but this hopefully should give you a start. I hope this helps.

 

[Just-me]

Thank you scracer.
It worked. I "cheated" and added the space to the title.
There was only one thing needed "tweaking".
I needed to convert the references to the title cells (C1, D1....) from relative to absolute (C$1, D$1...(to be able to copy and paste it down the B column.
I'm sure there are out there all kinds of more elegant/efficient ways and so, but, for me, you were my savior and I appreciate that!
Thanks again and... keep safe.
JM