James12513
New Member
- Joined
- Jul 24, 2014
- Messages
- 27
Hello all,
My friends at work and I have been bashing our heads together to try to come up with the most simple and efficient method of the below problem..
After a day of drawing up blanks we thought our last option was to come here for help - so we really would appreciate any ideas!!
What we want our final table to look this from the data below:
(please note this is a sample - there will be thousands of students to hundreds of teachers)
<tbody>
</tbody>
DATA:
<tbody>
</tbody>
My friends at work and I have been bashing our heads together to try to come up with the most simple and efficient method of the below problem..
After a day of drawing up blanks we thought our last option was to come here for help - so we really would appreciate any ideas!!
What we want our final table to look this from the data below:
(please note this is a sample - there will be thousands of students to hundreds of teachers)
Teacher | Student |
David Smith | Billy, Mike, Sarah, James, Maggie, Sophie |
Rachel Carne | Karen, Sara, Hassan, Amit, Andrew |
Sophie Patel | David, Paul, Peter, Rish, Rachel |
Zack Brown | Ameeta, Melissa, Abdul, Andy |
<tbody>
</tbody>
DATA:
Student | Teacher |
Billy | David Smith |
Mike | David Smith |
Sarah | David Smith |
Karen | Rachel Carne |
David | Sophie Patel |
James | David Smith |
Ameeta | Zack Brown |
Paul | Sophie Patel |
Sara | Rachel Carne |
Melissa | Zack Brown |
Abdul | Zack Brown |
Hassan | Rachel Carne |
Maggie | David Smith |
Sophie | David Smith |
Peter | Sophie Patel |
Andy | Zack Brown |
Amit | Rachel Carne |
Andrew | Rachel Carne |
Rish | Sophie Patel |
Rachel | Sophie Patel |
<tbody>
</tbody>