Your example show a maximum of 4 licenses per person - is that a safe assumption?
No, there could actually be 6 if all the quotes were filled.
I don't see that but it doesn't matter; as long as the number is fairly low, you can do this:
First, import the data into a new table. Next, add a PersonID field to this table, set it to auto-enter a serial number, and populate it with serial numbers.
Define a new table of Licenses with the following fields:
• LicenseID (Number, auto-enter serial number)
• PersonID (Number)
• LicenseNumber (Text)
• IssueDate (Text)
Now do a series of 6 imports, each time importing the PersonID and a pair of license number & date (do a find in the source table before each round to import only records that have data in the next pair of fields).
There are smarter methods, but this one is simple and easy to explain.
Sounds easy enough even for me.
I will try that this evening. Thanks for the simple instructions. Much appreciated.