Duplicate line data based on multiple items in 1

Question

I have a data with like 1000 rows and around 20 columns.

1 column contains multiple names corresponding to each row ID

I want to duplicate rows corresponding to that column names, with only 1 name to each duplicated row.

Like, row 1 column 20 has 2 names, so row 1 should be duplicated to contain 1 name each in column 20.

Row 7 column 20 might contain 4 names, so those rows will be duplicated 4 times with 1 name each.

Thanks

Isha_Gupta · Answer

It works. Thanks

FinnCharlton · Answer

@Isha_Gupta It sounds like you need the Text-to-Columns tool. Are the names separated by a delimiter, like a comma? If so, you can do something like this:

Before:

After:

Workflow attached, hope it helps!

Text To Columns.yxmd