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!
Solved! Go to 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.
Hi @Carlos77
You can use text to column like below. Use space as a delimiter and split option as to rows
Hope this helps : )
Happy to help : ) @Carlos77
Cheers and have a nice day!