Hello all
I wonder if anyone can help me/point me in the right direction.
I have a large dataset which has data about students in a school. Each student is in several classes. What I need to do, and am struggling is to filter the students for each class then populate a report with that group of students. I have over 100 classes so need to automate this process. I am really struggling with how to filter the data and then place it within the report. I need the whole process automated.
Here is some example data -
name Grade Grade Class 1 Class 2 Class 3 Class 4 xx 2 3 8G 8F 8D 8M xx 8J 8G 8E 8J xx 8E 8S 8G 8G xx 8S 8J 8E 8K
This s a small sample of the data. I need to select the students for each class then populate a report with that data for every class I have. Any pointers would be really helpful.
Regards