Hi, for our NGO, we get the students attendance data in a particular format from the App. The rows have following values -
Date - Subject - Volunteer - Students' names & Present/Absent (this student data in single cell).
I could definitely segregate the data from the single cell to multiple cells in the same row. BUT now how do I make a report where I can see if a student was present or absent for a subject date-wise or at least the total number of days a particular student has attended in that month, subject-wise.