View Single Post
 
Old 10-12-2012, 04:17 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline Windows Vista Office 2007
Novice
 
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default 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?
Attached Files
File Type: xlsx Book1.xlsx (8.7 KB, 3 views)
Reply With Quote