So, I have a project. don't we all. I need to combine all known UPC codes for a specific part number into a single cell with a semi colon between each UPC code. The data I have is available like this:
<colgroup><col><col></colgroup><tbody>
</tbody>
How would I combine all of the UPC codes for part number 1x3 BN into a single cell. Note that not all part numbers have same number of UPC codes, it can vary from 1-20. Any help is greatly appreciated.
| 1X3 BN | 102141 |
| 1X3 BN | 94913880897 |
| 1X3 BN | 94913885892 |
| 1X3 BN | 10668197024406 |
| 1X3 BN | 20690308000129 |
| 1X3 BN | 40032888005486 |
| 1X3 BN | 40032888100457 |
| 1X3 BN | 585-030 |
| 1X3 BN | 6818716389800 |
| 1X3 BN | 94913885892 |
| 1X3 BN | AT1X3 BN |
| 1X3 BN | BI1X3 BN |
<colgroup><col><col></colgroup><tbody>
</tbody>
How would I combine all of the UPC codes for part number 1x3 BN into a single cell. Note that not all part numbers have same number of UPC codes, it can vary from 1-20. Any help is greatly appreciated.
