Need a formula to return header if cell is not blank and concatenate the header names separated by comma

[bb19august]

Car	Bus	Train	Result
1	1		Car, Bus
	2	2	Bus, Train
1		No	Car, Train
7	3		Car, Bus
10		Yes	Car, Train

<tbody>
</tbody>

Request your help to have a formula in excel to get a result as shown above. Cells could have numbers or blanks or text. if there is any number/text in any cell(s)the header(s) has to copied and concatenated and separated by comma.

 

[Yongle]

In D2 copied down
=TRIM(SUBSTITUTE(IF(A2<>"",A$1,",")&IF(B2<>"",", "& B$1,"")&IF(C2<>"",", "&C$1," "),",,",""))

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​
1​	Car	Bus	Train	Result
2​	1​	1​		Car, Bus	=TRIM(SUBSTITUTE(IF(A2<>"",A$1,",")&IF(B2<>"",", "& B$1,"")&IF(C2<>"",", "&C$1," "),",,",""))
3​		2​	2​	Bus, Train
4​	1​		No	Car, Train
5​	7​	3​		Car, Bus
6​	10​		Yes	Car, Train
7​			Yes	Train

Sheet: Sheet2

 

[bb19august]

It worked as expected. Thank you so much for your time and help, Yongle.

 

[Yongle]

thank you for the fedback