Filter a column for specific value and creates a list from the corresponding rows

Dear All,

I have a database (ATTACHED) which contain name, roll number, courses taken etc. I want to create different file for different courses showing the roll number and name of the student who have written their name as REGISTER in the course.

I would be very thankful to all of you for your help.


Regards,
Shreejit