Merge cells based on the no. of cells that has values

Hi,

I am new to excel programming. Kindly help me in resolving my problems.

The requirement is to dynamically generate a template in sheet1 based on the data available in sheet2. I have attached a sample excel file.

For the given data in sheet2, when a button labeled 'Generate Template' is clicked, it should generate the sheet 1 as per the below requirement.

The script should identify the no. of unique values available in column C. For each value available in column C, it should identify the number of non-empty cells available from E in the corresponding row. For example, for the abc.doc available in C3, there are 2 validations from E3:G3. Based on this, the script should merge B2:C2 (2 cells).

Kindly help me in implementing it.

1. How do I identify the unique values available in a column - in specific column C ?
2. How do I identify how many cells have value from column E in a row ?
3. How do I dynamically merge cells based on the number of cells that have value after column E in sheet 2 ?

Thanks & Regards
Yuvi