Concatenating different columns from different rows

All,

I have created a sample excel file attached here.

I have provided the input in worksheet "Sheet1" and required output in worksheet "Output".

Could I get some assistance for creating a macro to produce the given output.

Thank you in advance.
KK

I faced some network problems, and could noyt post it. Anyway, it is a bit different approach, so will post now.


original message:
------
Probably real data is a bit better structured, but may be not.
The only difference is that in your sample output sheet you had 2 first entries finished with space (not "ab cd ef" but "ab cd ef ") - I assumed program shall not work like that. So the proposed code is:

Please Login or Register  to view this content.

Try it.