Forum Discussion
Trying to figure out formula
Before typing out my problem thanks for taking a moment to help. I am trying to figure out what formula needs to be used in order to populate and combine data from multiple cells into one. Say ...
Someone1Hello,
I've used the same case as you, to mark with an x (or any character) and retrieve the concatenated cell of the headings.
My formula is like this:
=IF(SUMPRODUCT(1*NOT(ISBLANK('Your-headings-range')))=0,"other",TEXTJOIN(", ",1,IF(therowrange="x",your-headings-range,"")))
I adapted it to exlude my info, but I must clarify that I used Table Names and not cells... Replace your headings range for $A$1:$A$3 and your row range, for the equivalent of the rows below for example: B1:B3.
Assuming Your Heading Range is A1:C1
and input Range is A2:C2
write below array formula in D2 and press ctrl + shift + enter
=TEXTJOIN(" ",1,IF((A2:C2="x"),$A$1:$C$1,""))