Conditional data transpose date wise

Dear all, need data transpose date wise , the date sequence should be start form lower date to upper date . please check the attached pic & excel file , here I have explain what I exactly want to do . attached file two sheet , input sheet for input data & output sheet for the actual results that I want
script.jpg

Please Login or Register  to view this content.

hi rcm, Thanks for replay , it transpose very well, but it was not being date wise , It will be vary according date . please check my pre post (snap shoot). But you macro showing same pattern (I mean it start form B, Q3, Q1, H/Y for all the scripts same)
script2.jpg

Please Login or Register  to view this content.

Please Login or Register  to view this content.

waw, that's crazy !!!!

Hi Jindon, its really nice job that you did for me . It works perfectly , I always appreciate your time saving code. thanks

Hi bsalv,
your code also works for me , but here is a problem , if I keep lots of data in the input sheet , it doesn’t give the output as well . but it works only for the particular input data range wise. However I appreciate your nice explanation with code . As I already got the solution so you might not waste your valuable time for the same issue. Thanks