What is the best way to format data From UPCSKU6293002038230485721, 2357550 To UPCSKU6293002038230485721629300203822357550 Thank you.

Adding repeat lines

What is the best way to format data From

UPC	SKU
62930020382	30485721, 2357550

Thank you.

Parse

If you set the Text to Columns tool to Split to Rows it should automatically repeat the UPC column (and any other columns).

Parse. Text to Columns. Split to ROWS.

Cheers,

Mark

Use a Text To Columns tool to split the SKU on , to rows

You may need to use a Data Cleanse tool to remove residual spaces.

Sample attached

I got the first part by split the columns... but how to get the second part to repeat the UPC column..

Thank you