Hi Saad & welcome to the forum

Can you explain in depth what is required ? Or better yet upload a sample file (follow the yellow banner at top for instructions) with similar structure of your original file & manually mock up the desired results after running the macro as illustration for us to be able to help