Fetch values from merged cells in macro

[dhivya.enjoy]

Hi Team,

As per my attached template I will have entries in column Y in merged cells. Those merged cell values belong to the same row of sample 2.
I am working on a development of macro where from these entries in excel I will fetch multiple csv files to upload in oracle tables through my web application.

Csv extraction all is working fine with the help of this forum. Now I need to fetch the values from this merged cell and in csv i need to put these values in two separate rows . For eg. refer attached sheet with filename sample_csv.

Also there is a single row space between each sample in the excel named TEMPLATE_EXCEL, when I extract csv I need to ignore these row spaces and put the entry in csv without any row spaces so please do help me with this also

Kindly help me with the code for both the need

Thanks in advance

Regards
Dhivya