Formula to find values in row and return headings

[JV0710]

Good Day
Please can I get some help with a formula to find the values in a row and return the matching headings

In the table below I would like to list the Groups that have values in each row (In the column named "mix")
Example: in Cell A2, match the value and return "Grp 4", In cell A3, match the values and return "Grp1, Grp6, Grp7, Grp9" etc

Thanks in Advance

 

[JV0710]

Concat was never in 2016 only 2019 & newer.


What version are they using?

They would be using Office 2010

 

[Fluff]

In that case you would need to use something like

=MID(IF(B2="","",","&B1)&IF(C2="","",","&C1)&IF(D2="","",","&D1),2,100)

 

[JV0710]

In that case you would need to use something like

=MID(IF(B2="","",","&B1)&IF(C2="","",","&C1)&IF(D2="","",","&D1),2,100)

Thanks very much Fluff . . . that works very nicely .

 

[Fluff]

Glad to help & thanks for the feedback.