Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Data converted from STDF shows 2 units looped 40x times. Overall I have 80 test instances. I want to convert data from Col2 to Col27 into a single column as saved on "sanitized" sheet