How to duplicate a row in excel and paste it right below the original row?

@thedriedseaweed88
Welcome to the forum

We suggest to do it at DataTable Level and write it back

Different options:

  • Essential For each …
  • LINQ

Assign activity:
dtResult = yourOrigDT.Clone

Assign Activity
dtResult =

(From d in yourOrigDT.AsEnumerable
From s In d("Role").ToString.Trim.Split(",".toCharArray, StringSplitOptions.RemoveEmptyEntries)
Let ra = new Object(){d("Name"), d("Age"), s.Trim}
Select r = dtResult.Rows.Add(ra)).CopyToDataTable
2 Likes