|
|
#1
10-12-2012, 04:17 AM
|
||||
|
||||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to Rename a Quick Part | sleake | Word | 14 | 10-14-2013 09:21 AM |
| VBA code for count w and write into another column in excel | tomlam | Excel Programming | 2 | 10-09-2012 03:56 AM |
| How to obtain the column “C” from column “A” and “B”? | Jamal NUMAN | Excel | 2 | 02-26-2012 01:28 PM |
| Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
 Need to search a column for a macth and return a result from a third column
|
pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
Windows Vista 
Office 2007
Threaded Mode