I have two table with some similar fields. The layouts are like this:
name, licenseid, ssn
id, name, licenseid, category1
I would like to combine the two tables and have each row layout as the following:
name, licenseid, ssn, category1, category2, category3
Table 2 has multiple entries for each person. So in theory there could be dozens of 'category' fields for each person.
Your current design is better, although I can't tell whether any single field from table1 provides a unique id which could be used in table2 (maybe ssn?). If ssn was unique on table1 then you would have table 2 as
Recordid, ssn, category
and link the two tables using the ssn.