How to transpose the datas of part code and supplier into row and column

I have a file having so many part code and supplier of each part code.

Now,I want that a part code should appear at once in a row and each supplier of that part code against that column.

Please refer attach file for more clarification.
In this file,column B and C consists of Part code and supplier.But the reqd.result is appearing from E to K column.

Is it possible from an excel formula?

I dont know if a formula can but a macro can. See attatched file, click button.


Marco_Ver.xlsm