Copy and insert rows until only individual strings remain in a cell

Question

Hi all,

I would need to copy entire rows (actual data has more columns than this example), whenever the column 'Tariff Code' contains more than one string of numbers, resulting in having just one string per row. Below example data how it should play out, it makes no difference to me if the commas will be left in the 'Tariff Code' -column after copying (or not):

Initial Data:

ShipmentTariff CodeA8803300099B680221C6403D96081019E290542F590410G6102309000, 6201930000H6201930000I6201930000, 6202990090J6201930000, 6202990090K48201000L392620, 476726M731700, 821410, 830590, 847290N830590O821410, 960810, 960820, 960840, 960920

Desired result:

ShipmentTariff CodeA8803300099B680221C6403D96081019E290542F590410G6102309000, G6201930000H6201930000I6201930000, I6202990090J6201930000,J6202990090K48201000L392620, L476726M731700, M821410, M830590, M847290N830590O821410,O960810, O960820, O960840, O960920

Thanks in advance!

JosephSerpis · Accepted Answer

Hi @Carlos77 you can use the Text to Columns tool with the configuration of Spilt to Rows with Delimeter , to achieve the desired results.

atcodedog05 · Accepted Answer

Hi @Carlos77

You can use text to column like below. Use space as a delimiter and split option as to rows

Hope this helps : )