Remove repeat headers with the help of VBA code

[Excel]

Hello Everyone, 

I have tried the VBA code and it works, but i click RUN button multiple times.

like - 

So, how to normalize this with the help of VBA code?

Please help.

Here is a attached file.

[#2 · Accepted solution]

@Excel 

We had already resolved this in earlier discussions, Zan. See Add with the help of VBA code. 

[#3]

Thank you for the response sir:smiling_face_with_smiling_eyes::smiling_face_with_smiling_eyes: