I'm not understanding the problem. One row in Excel is going to one row in ID.
Is the issue the formatting in ID?
Looks to me as if you want separate pages for each "course code" section. Data Merge is strictly a one record, one output module and is not capable of looking at the actual data and sorting in any way.
One or more of the commercial catalog plugins might be able to do this, or you can break the data into sections by specifying a range of records to merge, or you can change the way you put together the records in the data file so that each course code is a single line.
@sea_sparrow – all that can be done with scripting InDesign.
Loading the Excel document, splitting the sections, making individual tables, applying the headline and the header row, doing the layout of the table, let all individual tables flow in one story or individual InDesign files for every table…
You could send me a PM to get an offer.
This is an issue of trying to do a one-to-many relationship database merge in InDesign (e.g. one course can have many unit codes). InDesign's Data Merge can only handle one-to-one relationship database merges.
This has been illustrated in another recent post: http://forums.adobe.com/message/5888625#5888625
I'd go with Uwe's suggestion of simply importing the table from excel into indesign as flowing text and format the file from there.
And it depends on the number of single tables, if automating this by script will do you a favour…
If its a task you have to perform eg. every month, it could be worth the effort, too.