Conditionally data transpose by macro

[nur2544]

Dear all, I want to transpose data form one sheet to another sheet with the help of macro. It is little bit difficult
To explain details but in the attached file I have shown by color mark what need to require , please go through the attachment .

[p24leclerc]

the following macro is, at least, working for the data you provided. Try it on some more.

Please Login or Register  to view this content.

[nur2544]

Hi Pierre, Outstanding job, it works perfectly , no error , no bugs , everything is alright, thanks for your valuable time , & take care…