Some time we get data in Hierarchy format with merged cell format.

Here is the link with the sample data and with the code to unmerge and fill the merge cell data in all the cells.

Fill Merge Cell Hierarchy