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

[Carlos77]

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:

Shipment	Tariff Code
A	8803300099
B	680221
C	6403
D	96081019
E	290542
F	590410
G	6102309000, 6201930000
H	6201930000
I	6201930000, 6202990090
J	6201930000, 6202990090
K	48201000
L	392620, 476726
M	731700, 821410, 830590, 847290
N	830590
O	821410, 960810, 960820, 960840, 960920

Desired result:

Shipment	Tariff Code
A	8803300099
B	680221
C	6403
D	96081019
E	290542
F	590410
G	6102309000,
G	6201930000
H	6201930000
I	6201930000,
I	6202990090
J	6201930000,
J	6202990090
K	48201000
L	392620,
L	476726
M	731700,
M	821410,
M	830590,
M	847290
N	830590
O	821410,
O	960810,
O	960820,
O	960840,
O	960920

Thanks in advance!

[JosephSerpis · Accepted solution]

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 solution]

Hi @Carlos77 

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

Hope this helps : )

[atcodedog05]

Happy to help : ) @Carlos77 

Cheers and have a nice day!