I've tried so many ways to make this work. I'm creating a 'Courses with Grades' Crystal report
(v11.5) using 'Format with Multiple Columns', but I can't align the columns. There are large gaps in between each column because the 'course' is repeated between the grade columns (but hidden). I want the 3 grades more right justified and the course name (column) left justified. I've adjusted the column widths many ways.
Also, the data is being ordered numerically. That's not the order that the grades were earned.

Course Name Semester 1
Semester 2
Final
Language Arts 88
91
93
Math 92
94
96
Science 96
97
98


I tried creating formulas for the grades, in order to get them in the correct chronological order earned, but the grades are staggered in 3 different rows.

Course Name Sem 1
Sem 2
Final
Language Arts
89
Language Arts
91
Language Arts 93

Many thanks, I appreciate your suggestions.