if find blank cell in coloum need to take the header name in remarks

[shrinivasmj]

if find blank cell in coloum need to take the header name with comma after each word in remarks

<colgroup><col></colgroup><tbody>
</tbody>

Service Point No.	Source No. (11 Digit Pole No.)	Mobile / Landline No.	Service Main (UG/OH)	Supply (1/3)	REMARKS
	10000160985		UG	1	Service Point No. ,Mobile / Landline No. ,
1		9845612589	UG	1	Source No. (11 Digit Pole No.)
	10000160985			1	Service Point No. , Mobile / Landline No. , Service Main (UG/OH)

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Andrew Poulsom]

How about?

=TRIM(IF(LEN(A2),"",A$1&", ")&IF(LEN(B2),"",B$1&", ")&IF(LEN(C2),"",C$1&", ")&IF(LEN(D2),"",D$1&", ")&IF(LEN(E2),"",E$1&", "))

 

[shrinivasmj]

hi need one more step to add here need to modify the formula

=TRIM(IF(LEN(A2),"",A$1&", ")&IF(LEN(B2),"",B$1&", ")&IF(LEN(C2),"",C$1&", ")&IF(LEN(D2),"",D$1&", ")&IF(LEN(E2),"",E$1&", "))

in remarks its need to remove the last comma and add the words ( is not available ) if single blank cell found ,

if more then one blank cell then add at last words as ( are not available )

 

[Andrew Poulsom]

Here you are:

=SUBSTITUTE(TRIM(IF(LEN(A2),"",A$1&", ")&IF(LEN(B2),"",B$1&", ")&IF(LEN(C2),"",C$1&", ")&IF(LEN(D2),"",D$1&", ")&IF(LEN(E2),"",E$1&", ")),",","",COUNTBLANK(A2:E2))&IF(COUNTBLANK(A2:E2)=1," is "," are ")&" not available"