How do you have this line: Jane, Doe, teacher, math?
A line in a single cell?
If so, I may be able to play around with it some tonight.If it was me, I would probably use VBA and DAO Recordsets, and loop through my data and write the results to a new table.