T
Tiziano
I am using Excel 2000.
I have a spreadsheet with part numbers in col. A (the same
part number can appear multiple times) and purchase order
numbers in col. B (a purchase order number is never shared
by multiple instances of the same part number). The list is
very long!
I need to import this data into another file which shows (in col.
A) all the part numbers that we have (each part number appears
only once in this spreadsheet). The problem is that I have to
list ALL the purchase order numbers related to the same part
number on one row, starting in col. C... So, while for some part
numbers there could be no existing purchase order number or
only one purchase order number, for others there could be several
purchase order numbers to list on the same row! (Probably ten
purchase order numbers at the most.)
Is this possible with an Excel formula?
I have a spreadsheet with part numbers in col. A (the same
part number can appear multiple times) and purchase order
numbers in col. B (a purchase order number is never shared
by multiple instances of the same part number). The list is
very long!
I need to import this data into another file which shows (in col.
A) all the part numbers that we have (each part number appears
only once in this spreadsheet). The problem is that I have to
list ALL the purchase order numbers related to the same part
number on one row, starting in col. C... So, while for some part
numbers there could be no existing purchase order number or
only one purchase order number, for others there could be several
purchase order numbers to list on the same row! (Probably ten
purchase order numbers at the most.)
Is this possible with an Excel formula?