Vb macro coding for transpose - complete coding?

Dear Jindon,
Thank you for the amazing code.... its working.. My heartfelt thanks to you.. you saved my head from my Boss....
could you please do me another small help?????
the code what you gave has to be little modified according to the following excel sheet.. every time I have to copy an paste these columns separately in a new sheet and then I have to work with your code which is time consuming. it would be highly grateful and helpful for me, if you able to modify this code with the following attached excel sheet. I think maybe my question may not that much clear for you and so I m attaching the full excel sheet with this for your kind reference and easy understanding...
please oblige and do the needful...

Thanks & Regards,
Dharani.