Hi Prince,

Below is the link where you can find the same as you want.

Fill Merge Cell Hierarchy | Power Desk

There i have uploaded an excel file with sample data with two different method. Use what is helpful to you.