Ah, I see what you're saying. I'm playing around right now and am blanking on a simple way to do this. So, here's my best attempt -- I'll post again if I figure out something simpler!
1. New plan: let's use two Transpose Tasks instead of Split Columns. For the first Transpose task, Transpose variable is: Teachernm. Group analysis by variables are: name, dob. In the Options pane, set a prefix of Teachnm_course. The transpose task will automatically handle the numbering (1,2,3,...).
2. Second transpose task, Transpose variable is: school. Group analysis by variables are: name, dob. In the Options pane, set a prefix of school_course.
3. Use a Query Builder to join these two tables. Join based on name, dob. Drag all the columns into the select data area except the columns named SOURCE or LABEL.
That should work. Again, if I figure out a better way to do it, I'll let you know. The other solution I came up with involved Transpose, then Stack Columns, then a Query Builder, then Split Columns. Not pretty! 🙂