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.

[TABLE="width: 1024"]
<tbody>[TR]
[TD]Service Point No[/TD]
[TD]Source No. (11 Digit Pole No.)[/TD]
[TD]Mobile / Landline No[/TD]
[TD]Service Main (UG/OH)[/TD]
[TD]Supply (1/3)[/TD]
[TD]Phase (R/Y/B)[/TD]
[TD]Meter Make[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD]+919845898986[/TD]
[TD]UG[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SOURCE NO. (11 DIGIT POLE NO.), PHASE (R/Y/B), METER MAKE,[/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]g[/TD]
[TD]+910005855555[/TD]
[TD]UG[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]LT-LTD[/TD]
[TD]PHASE (R/Y/B),[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]10000256656[/TD]
[TD] [/TD]
[TD]UG[/TD]
[TD]1[/TD]
[TD]523553[/TD]
[TD]LT-LTD[/TD]
[TD]SERVICE POINT NO, MOBILE / LANDLINE NO,[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col span="2"><col></colgroup>[/TABLE]