Concatenate the header if cells are not blank in a range

[Narendra Kumar]

Dear Sirs,

Good evening,
Need your help to get desired answer.. with formula like

If cell is non blank in 2nd row(B3:G3) than CONCATENATE the header of non blank cells in range (B3:G3) into H column as result.
Example :

INV/CHG-NAME <colgroup><col width="106"></colgroup><tbody> </tbody>	ABC <colgroup><col width="64"></colgroup><tbody> </tbody>	DFG <colgroup><col width="64"></colgroup><tbody> </tbody>	IHTY <colgroup><col width="64"></colgroup><tbody> </tbody>	UUUU <colgroup><col width="64"></colgroup><tbody> </tbody>	BBBB <colgroup><col width="64"></colgroup><tbody> </tbody>	TOTAL <colgroup><col width="64"></colgroup><tbody> </tbody>	RESULT <colgroup><col width="136"></colgroup><tbody> </tbody>
ATR1234 <colgroup><col width="106"></colgroup><tbody> </tbody>	568.00 <colgroup><col></colgroup><tbody> </tbody>		15.00 <colgroup><col></colgroup><tbody> </tbody>		155.00 <colgroup><col></colgroup><tbody> </tbody>	738.00 <colgroup><col></colgroup><tbody> </tbody>	ABC/IHTY/BBBB <colgroup><col width="136"></colgroup><tbody> </tbody>
CRT5678 <colgroup><col width="106"></colgroup><tbody> </tbody>		1,536.00 <colgroup><col></colgroup><tbody> </tbody>		852.00 <colgroup><col></colgroup><tbody> </tbody>	2.00 <colgroup><col></colgroup><tbody> </tbody>	2,390.00 <colgroup><col></colgroup><tbody> </tbody>	DFG/UUUU/BBBB <colgroup><col width="136"></colgroup><tbody> </tbody>
FHD2341 <colgroup><col width="106"></colgroup><tbody> </tbody>	852.00 <colgroup><col></colgroup><tbody> </tbody>		862.00 <colgroup><col></colgroup><tbody> </tbody>	850.00 <colgroup><col></colgroup><tbody> </tbody>		2,564.00 <colgroup><col></colgroup><tbody> </tbody>	ABC/IHTY/UUUU/ <colgroup><col width="136"></colgroup><tbody> </tbody>
JKD6785 <colgroup><col width="106"></colgroup><tbody> </tbody>	86.00 <colgroup><col></colgroup><tbody> </tbody>		952.00 <colgroup><col></colgroup><tbody> </tbody>		758.00 <colgroup><col></colgroup><tbody> </tbody>	1,796.00 <colgroup><col></colgroup><tbody> </tbody>	ABC/IHTY/BBBB/ <colgroup><col width="136"></colgroup><tbody> </tbody>
MNB5876 <colgroup><col width="106"></colgroup><tbody> </tbody>	85.00 <colgroup><col></colgroup><tbody> </tbody>	85.00 <colgroup><col></colgroup><tbody> </tbody>	12.00 <colgroup><col></colgroup><tbody> </tbody>		852.00 <colgroup><col></colgroup><tbody> </tbody>	1,034.00 <colgroup><col></colgroup><tbody> </tbody>	ABC/DFG/IHTY/BBBB <colgroup><col width="136"></colgroup><tbody> </tbody>

<tbody>
</tbody>

Thanks in advance for your help.

 

[Narendra Kumar]

Mr Peter SSs,

Thank you very much for your solution, It is exactly what i want.

 

[Peter_SSs]

Mr Peter SSs,

Thank you very much for your solution, It is exactly what i want.

You are very welcome.