I have a spreadsheet of students assigned to a specific teacher on a specific day for tutoring and I would like to create a single sheet that list all teachers individually in a row and then shows the students assigned to them for each day. I have tried VLOOKUP, MATCH, INDEX with no luck.
Data I am pulling from.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 120px"><col width="120"><col width="120"><col width="120"><col width="120"></colgroup><tbody>
[TD="align: center"]MON[/TD]
[TD="align: center"]TUE[/TD]
[TD="align: center"]WED[/TD]
[TD="align: center"]THU[/TD]
[TD="align: center"]STUDENT[/TD]
</tbody>
Desired Results
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 120px"><col width="120"><col width="120"><col width="120"><col width="120"></colgroup><tbody>
[TD="align: center"]MON[/TD]
[TD="align: center"]TUE[/TD]
[TD="align: center"]WED[/TD]
[TD="align: center"]THU[/TD]
</tbody>
Thanks in advance for the help.
Data I am pulling from.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Mr. Smith | Mr. Smith | Library | Mrs. Jones | John Doe |
Mrs. Jones | Mrs. Jones | Library | LIbrary | Jane Doe |
Mr. Smith | Mr. Doe | Mrs. Jones | Comp Lab | John Smith |
<colgroup><col style="width: 120px"><col width="120"><col width="120"><col width="120"><col width="120"></colgroup><tbody>
[TD="align: center"]MON[/TD]
[TD="align: center"]TUE[/TD]
[TD="align: center"]WED[/TD]
[TD="align: center"]THU[/TD]
[TD="align: center"]STUDENT[/TD]
</tbody>
Desired Results
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Mr. Smith | John Doe John Smith | John Doe | ||
Mrs. Jones | Jane Doe | Jane Doe | John Smith | John Doe |
Mr. Doe | John Smith | |||
Library | John Doe Jane Doe | Jane Doe | ||
Comp. Lab | John Smith |
<colgroup><col style="width: 120px"><col width="120"><col width="120"><col width="120"><col width="120"></colgroup><tbody>
[TD="align: center"]MON[/TD]
[TD="align: center"]TUE[/TD]
[TD="align: center"]WED[/TD]
[TD="align: center"]THU[/TD]
</tbody>
Thanks in advance for the help.