Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What I need to do is build a list of items, but seperated with
commas.. So..I have built this file to have a Brand, Model, Part criteria. There is 53k or so entries or rows. What I need to do is.. Sort each Part Number probably around 1200 Parts which will show me each Brand that takes that part in a list. I need some sort of automation to create this list of Brands, but have them seperated by commas.. For example.. These Part Numbers in Column C fit These Models in B and Brands in Column A Col-C P/N Col-B Model number Col-A Brand 1683 A altima 1683 B altima 1683 C altima 1683 D altima 1683 E snoma 1683 F snoma 1683 G snoma 1683 H snoma 1683 I tscny As you can see there is some redundancy in the Brand Column on this Part number. What I need to do is have a final ouptut in a new colum look like this.. 1683,altima,snoma,tscny Any ideas on how to achieve this? I think Excel can handle it, but I'm not sure. Please advise. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
building list | Excel Worksheet Functions | |||
How to organize my HUGE to do list? | Excel Discussion (Misc queries) | |||
huge huge excel file... why? | Excel Discussion (Misc queries) | |||
File got huge | Excel Discussion (Misc queries) | |||
The XLS file is huge! | Excel Programming |