It won't be pretty no matter what approach you use.
There is a transform option in Excel that swaps rows for columns. Might be able to export to excel, transform and then import into Filemaker...
I just tried that. But that's not going to help.
The good thing now is that at least the Student ID's are in te right place. But use "Transpose" and everything get's turned.
And especially the fact that you always have two (sometimes three) fields that belong together doesn't make it any easier.
Big bummer :(
You might, and that's a big might given the schema, find a solution in a virtual list. Google filemaker virtual list.
Hmmm, you could set up a layout with all the fields on it and used a looping script to move from field to field with Go to next field and used Get (ActiveFieldname) to extract the name of the field in order to enter it as data into a record in a new table...
When you say setup a layout with all the fields on it, can you do this since the fields needed are on multiple tables connected to one main table?
If the relationship is valid and either one to one or many to one, yes.
Otherwise, you may need a layout for each table.
Take a look at the get functions and set field by name as ways to indirectly reference fields and their contents as well as determine the table and filed names of the field that currently has the focus.