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)
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Teacher
[/TD]
[TD="align: center"]Student
[/TD]
[/TR]
[TR]
[TD]David Smith
[/TD]
[TD]Billy, Mike, Sarah, James, Maggie, Sophie
[/TD]
[/TR]
[TR]
[TD]Rachel Carne
[/TD]
[TD]Karen, Sara, Hassan, Amit, Andrew
[/TD]
[/TR]
[TR]
[TD]Sophie Patel
[/TD]
[TD]David, Paul, Peter, Rish, Rachel
[/TD]
[/TR]
[TR]
[TD]Zack Brown
[/TD]
[TD]Ameeta, Melissa, Abdul, Andy
[/TD]
[/TR]
</tbody>[/TABLE]
DATA:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Student
[/TD]
[TD="align: center"]Teacher
[/TD]
[/TR]
[TR]
[TD]Billy
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Mike
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Sarah
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Karen
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]David
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
[TR]
[TD]James
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Ameeta
[/TD]
[TD]Zack Brown
[/TD]
[/TR]
[TR]
[TD]Paul
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
[TR]
[TD]Sara
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]Melissa
[/TD]
[TD]Zack Brown
[/TD]
[/TR]
[TR]
[TD]Abdul
[/TD]
[TD]Zack Brown
[/TD]
[/TR]
[TR]
[TD]Hassan
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]Maggie
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Sophie
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Peter
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
[TR]
[TD]Andy
[/TD]
[TD]Zack Brown
[/TD]
[/TR]
[TR]
[TD]Amit
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]Andrew
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]Rish
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
[TR]
[TD]Rachel
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
</tbody>[/TABLE]
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)
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Teacher
[/TD]
[TD="align: center"]Student
[/TD]
[/TR]
[TR]
[TD]David Smith
[/TD]
[TD]Billy, Mike, Sarah, James, Maggie, Sophie
[/TD]
[/TR]
[TR]
[TD]Rachel Carne
[/TD]
[TD]Karen, Sara, Hassan, Amit, Andrew
[/TD]
[/TR]
[TR]
[TD]Sophie Patel
[/TD]
[TD]David, Paul, Peter, Rish, Rachel
[/TD]
[/TR]
[TR]
[TD]Zack Brown
[/TD]
[TD]Ameeta, Melissa, Abdul, Andy
[/TD]
[/TR]
</tbody>[/TABLE]
DATA:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Student
[/TD]
[TD="align: center"]Teacher
[/TD]
[/TR]
[TR]
[TD]Billy
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Mike
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Sarah
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Karen
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]David
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
[TR]
[TD]James
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Ameeta
[/TD]
[TD]Zack Brown
[/TD]
[/TR]
[TR]
[TD]Paul
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
[TR]
[TD]Sara
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]Melissa
[/TD]
[TD]Zack Brown
[/TD]
[/TR]
[TR]
[TD]Abdul
[/TD]
[TD]Zack Brown
[/TD]
[/TR]
[TR]
[TD]Hassan
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]Maggie
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Sophie
[/TD]
[TD]David Smith
[/TD]
[/TR]
[TR]
[TD]Peter
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
[TR]
[TD]Andy
[/TD]
[TD]Zack Brown
[/TD]
[/TR]
[TR]
[TD]Amit
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]Andrew
[/TD]
[TD]Rachel Carne
[/TD]
[/TR]
[TR]
[TD]Rish
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
[TR]
[TD]Rachel
[/TD]
[TD]Sophie Patel
[/TD]
[/TR]
</tbody>[/TABLE]