Need to fill the value based on the datatable into another excel

Datatable


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

Please suggest linquery

Excel file