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?
|