Solution for Mapping and Writing Data Between Two Tables

hi, anyone has a solution to 'map column data' between two tables and then write to second table as per the match? Write to another table just create new rows. We intend to write data as per the matched values. Any solution?