merging duplicate data into one cell

[Punquey]

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:

[TABLE="width: 718"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]1X3 BN[/TD]
[TD]102141[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]94913880897[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]94913885892[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]10668197024406[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]20690308000129[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]40032888005486[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]40032888100457[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]585-030[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]6818716389800[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]94913885892[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]AT1X3 BN[/TD]
[/TR]
[TR]
[TD]1X3 BN[/TD]
[TD]BI1X3 BN[/TD]
[/TR]
</tbody>[/TABLE]


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.

 

[Fluff]

Glad to help & thanks for the feedback