Writing into a new col (spreadsheet or data table)

@barryrodick

You can write into Datatable as below

Use ForEach Row activity → create a variable in Index

Use Assign Activity
DT.Rows(index).Item("ColumnName").Tostring = "Text you need to set"

For Reference you can check below post

Mark as solution if this helps

Thanks