Copy data from a sheet and Paste in another sheet into Merged cells

Dear Friends,

I need to copy data from unmerged cells to merged cells.

I have around 5500 data and that needs to be pasted in another sheet in which there are some merged cells.

I attached a sample file for your kind reference and solution.

Please help me to find the solution.

Thanking you and in anticipation.

acsishere.

Any Help, Please.....

I need a VBA solution.

Please help me.

Dear Friends,

Please help me to find a solution.

Thanking you and in anticipation.