transpose text to another sheet

Need help with a VBA macro that will make copying unique data to another sheet and make a transposition to the corresponding data
I have attached a file
Thanks advance

Here is something which should work for you.

Leith Ross, a forum moderater on ExcelForum, help me with this same thing earlier this year.

http://www.excelforum.com/excel-prog...s-columns.html

I've taken his macro and modified it slightly for your needs. There is a button on the sheet which you can just click to see the results.

You're welcome and thanks for the feedback