怎么通过函数实现最右一列结果的输出？如图所示

img


怎么通过函数实现最右一列结果的输出？如图所示。当结果值为1的时候，取对应的列名，并合并到一起

麻烦说明一下是要求是用什么工具或者什么开发语言实现？
excel公式？数据库sql？python或java等开发语言的表格处理？

EXCEL的话，下面是一种方案，用if判断，然后字符串拼接，用字符串替换把两个逗号变成一个逗号，最后把首尾的逗号去掉。
注意，我这里只拼了三个字段作为示意

=MID(SUBSTITUTE(","&IF(B2=1,$B$1,"")&","&IF(C2=1,$C$1,"")&","&IF(D2=1,$D$1,"")&",",",,",","),2,LEN(SUBSTITUTE(","&IF(B2=1,$B$1,"")&","&IF(C2=1,$C$1,"")&","&IF(D2=1,$D$1,"")&",",",,",","))-2)

img