How to organise Attendance data if it is in the single cell.

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.

Little Urgent. PLEASE HELP