The Data worksheet is how my data is formatted. There are an known number of rows, some could have 100, 3, or 1000. The macro needs to loop until end of last row.
On the Result worksheet, it's stringing together all the similar part numbers.
Check the attached xls for an example. example.xls