Duplicating (or moving) records to a different table with automations

The most direct route is just to hunker down and do each of the 25 fields.  There is an alternative to set up a saved table to table import,(which can be triggered by an Automation)  and if the fields names are the same in the two tables it will guess correctly at the field mapping.  But then you will need to filter which record is copying across and that would take a lot of explaining by me and a new table setup to hold the focus record and new relationships.  I think in this case,  KISS and a bit of brute force is the best way.