1 Like
Hi use this
Dictvalues=Datatable.AsEnumerable.todictionary(function(×) ×(0).tostring,function(r) r(1).tostring
Then use for each row in datatable for dt1
Assign
Currentrow(2).tostring=dictvalues(currentrow(0).tostring)
Outside of for each use write range workbook for datatable1
Hope this helps cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.