Hi there, not sure exactly how to explain this but here goes.
I have a table containing a student ID and multiple tasks for each student as task1subject, task1, task2subject, task2, task3subject, task3.
I want to know if its possible to build a query which will group the tasks under one name...