Hi everyone,

I'm trying to populate 3 tables from 1 record, Not sure if I named it
right, here's an explanation of what I wanted to happen

Record 1:
field1| field2| field3| field4| field5| field6| field7|

from this record, I would like to make these 3 tables
Table 1
field1| field4| field6

Table 2
field2| field3| field5|

Table 3
field7|

A complication is that there's no primary key to the original table.

Is there any way to do this?

Thank you for any help you can provide