For each excel row from bottom up

Based on your inputs a regex could look like this:
with refering to Groups:

And above suggestion just need a small adaption

Assign Activitiy
dtResult = dtDataClone

Assign Activity
dtResult =

(From d in dtData.AsEnumerable
Let mts = System.Text.RegularExpressions.Regex.Matches(d("Items").toString, "([A-Z]) (\d+)")
From m in mts.Cast(Of Match)
Let ra = new Object(){d("ID"), m.Groups(1).Value, m.Groups(2).Value }
Select r = dtResult.Rows.Add(ra)).CopyToDataTable
1 Like