Calculate average of similar rows cell in Excel


how can we write it into separate excel instead of write line??

Write range or Append range can be used.

i did that…but it’s throwing error…when i used write range as row.Item(0).tostring+"-"+total.Tostring
that it cannot be converted to datatable

Write cell can be used in that case.
Even the values can be stored in the datatable using assign and further Write range can be used.

its giving error that string cannot be converted to dataTable when iam using assign to put values in dataTable

Please find the below example to edit the values in datatable.