its a side by side merge case, so we would not handle with Join DataTable activity or Merge Datatable Activity (result from this would 2 rows, but not the flatten one 1 row)
Suraj described already the Excel way to do this
For datatable / LINQ approach have a look here: