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 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!
It works. Thanks