Copy Data from one sheet to other to change data layout

Hi Mike:

You are great.
Saved me bunch of hours.
Its working....I will let you know if any further problem.

Thanks
Riz