A2 contains Clay;Mug;Blue and A3 contains Glass;Jar;Clear. Column B already holds stock counts. Leave the original descriptions and stock available for the reconciliation.
Preview the split before choosing a destination
Select A2:A3 in Ulet and choose Data → Text to Columns → Split by Semicolon. Confirm the preview is two rows by three columns. Set the destination to D2 after checking that every cell in D2:F3 is empty, then choose Import.

Illustrated starting layout with nearby data to preserve.
Check a preserved cell and the last result row
Verify A2 still contains the joined text, B2 has its original count and D3:F3 says Glass, Jar, Clear. If a source row has an extra delimiter or a missing field, inspect how it appears in the preview before importing the full range.

Illustrated footprint check after import.



