adamelston
New Member
- Joined
- Jul 22, 2016
- Messages
- 31
Hi, I've been trying unsuccessfully to populate a table (T2) with info from a table (T1), perhaps using an 'x' or 'y' to show which student is on which course. T1 is:
<tbody>
</tbody>
and T2 is:
<tbody>
</tbody>
I've been trying index/match but I am not sure how to deal with two criteria, I would be very grateful for any help.
Thanks,
StudentID | Course |
a1 | French |
a2 | Math |
a3 | English |
a4 | Science |
a5 | French |
a6 | English |
a1 | Science |
a3 | French |
<tbody>
</tbody>
and T2 is:
StudentID | English | Math | Science | French |
a1 | ||||
a2 | ||||
a3 | ||||
a4 | ||||
a5 | ||||
a6 | ||||
a7 | ||||
a8 | ||||
a9 | ||||
a10 |
<tbody>
</tbody>
I've been trying index/match but I am not sure how to deal with two criteria, I would be very grateful for any help.
Thanks,
Last edited: