Merge the same values using in EPPLUS

Question

Hi Frnds,

               I need to merge the dynamically when my first column values are same in EXCEL Generation using EPPLUS. My column data was change when employees joining and termination. So, I want to konw How to dynamically merge if the columns are same values and I need to Highlight the each Total row only with backgroud color. I attached the excel file for your reference. Am a beginner this is my first time I am using the EPPLUS.

 

Please help me to get resolved.