Can you maybe post a screenshot of automation in question, its kinda hard to figure out what is wrong if we don’t know how did you setup your automation.
On the side note, if you are manually creating new record, as soon as you press add new record automation triggers and basically copy the record you created before you populate it with all the information, it copies empty new record. Workaround for this is that you use form to populate your new record because form populates all fields at same time, or maybe make so your automation have delayed triggering so you manage to populate all fields before it triggers.
Unless the record from Table 1 was created via a form or API call (or duplicated from a record which had fields filled in), all fields which are not calculated will come in as empty.
You should probably should be using “when record enters a view” or “when record meets conditions” so that the automation waits until the appropriate fields get filled in before it copies the record to a different table.