Mazbuka
New Member
- Joined
- Sep 23, 2018
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
I have a big list of students in Col A & their school form in Col B. I list each unique form as column headers from C onwards and underneath each header I want the list of students in that form.
My data sample looks like this:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The resultant data needs to be listed as below:
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
My data sample looks like this:
<colgroup><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The resultant data needs to be listed as below:
C | D | E | ||
1 | Y01A | Y01B | Y02C | |
2 | John | Mary | Paul | |
3 | June | Brian | Mick | |
4 | Don | Karen | ||
5 | Pat | |||
6 | ||||
7 | ||||
8 | ||||
9 | ||||
10 |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>