var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Compressed crosstab query
I have a table with the following layout:
I want to convert this table so the information is displayed as follows:
studentID, subject1, subject2, subject3, subject4, subject5.
1, English, Maths, Science, Art, Business.
2, English, Maths, Science, History, .
3, English, Maths, Science, RE, Music.
The closest I have found is using a crosstab query but this lists the subject names as column headings and spreads the results across a wide datasheet, leaving a lot of blank cells.
Is there any way to achieve this?
Try having a look at this