find blanks cell in column and take header name in remarks ,

[shrinivasmj]

hi

find blanks cell in column and take header name in remarks ,

I need to remove last comma and add last sentence, if only one blanks cell is there add at last ( is not available )

if more than 2 blanks cell need to add at last ( are not available )

formula used in remarks

=UPPER(TRIM(IF(LEN(A2),"",A$1&", ")&(IF(LEN(B2),"",B$1&", ")&(IF(LEN(C2),"",C$1&", ")&(IF(LEN(F2),"",F$1&", ")&(IF(LEN(G2),"",G$1&", ")))))))

data sample below.

Service Point No	Source No. (11 Digit Pole No.)	Mobile / Landline No	Service Main (UG/OH)	Supply (1/3)	Phase (R/Y/B)	Meter Make	Remarks
1		+919845898986	UG	1			SOURCE NO. (11 DIGIT POLE NO.), PHASE (R/Y/B), METER MAKE,
g	g	+910005855555	UG	1		LT-LTD	PHASE (R/Y/B),
	10000256656		UG	1	523553	LT-LTD	SERVICE POINT NO, MOBILE / LANDLINE NO,

<tbody>
</tbody><colgroup><col><col><col><col><col><col span="2"><col></colgroup>