Combine rows to print on one label
 

School Pupil ID LastName FirstName Grade Course/Grade
Clear Creek 210310 Archer Heath 5 MUSIC S
Clear Creek 210310 Archer Heath 5 SOC ST A
Clear Creek 210310 Archer Heath 5 MATH B
Clear Creek 210310 Archer Heath 5 RDG C
Clear Creek 210310 Archer Heath 5 SCI/HEA D
Clear Creek 210310 Archer Heath 5 CIT A

I all this information to print on a SINGLE label. Using my Excel
spreadsheet as my data source, when I set up my label, one label prints for
each course.