Dear oeldere , thanks for your concern degrading this , with respect you , now come to the point I was raised a thread & after some time I got a response from you which was really appreciated. but that macros output was not fulfillment my requirements , which I mentioned you like below comments.
Hi oeldere, thanks for replay, It is not working for me , please check the attachment, here I have mention that Column A is my input data. And from this input I need output as like row J2 to O2 .
And I was waiting for your reply , when I saw that I didn’t get any reply from you, I assume that my thread may be complex. after that I thought alternative way and that is formula solution (though it will not be fulfillment my requirement , but it will partial help me)

I think it was my fault , I might not ask the question properly, but I was replay also with my actual asking ,how ever I always respect all forum expert those are working for us with open heart . I always try to abide by all the forum Rules & regulation of excelforum. Some time there might be mistake due to lack of my English competence.