Having a datatable ...need to fill the value based on the datatable into another excel

I have a data table

I need to fill value from the above datatable into a another excel under each city based on the ID
the excel looks like below

Need Linquery or someother best approach

excel file

You can apply filter based on the Id (or) you can apply filter using select.
Example -
dataTable.select(Id=‘value’)// get rows
//iterate rows using for each - you can get row and stored in a varabe item
item.ItemArray(0) - you get 1st column value

This iteration is time consuming…can u pls suggest linquery