I have a spreadsheet that contains over 3000 rows of student data. The last two columns contain Staff Code and Class. I am looking for a way to add the staff code to the class (sometimes we have two or maybe three teachers). What I normally do is use the concatenate function. I sort the spreadsheet by class then go down and if that student has two teachers I manually copy the one Staff Code and paste it in the first cell (e.g CMF - GH) and then drag the staff code down until I reach the end of that class....and I do this for every shared class. There must be an easier way to do this. My eyes hurt scrolling down that much data.
<colgroup><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col span="2"></colgroup><tbody>
</tbody>
so I add staff Code by manually adding (CMF - RK) and using the concatenate function the end result looks like this 7-ART-1e (CMF - RK)
The query needs to look at class 7-ART-1e and in this instance we have two teachers sharing the group, add their code as above.
Thanks for looking at my post.
<colgroup><col span="2"></colgroup><tbody></tbody>
StaffCode | Class |
CMF | 7-ART-1e |
CMF | 7-ART-1e |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
RK | 7-ART-1e |
RK | 7-ART-1e |
RK | 7-ART-1e |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
so I add staff Code by manually adding (CMF - RK) and using the concatenate function the end result looks like this 7-ART-1e (CMF - RK)
The query needs to look at class 7-ART-1e and in this instance we have two teachers sharing the group, add their code as above.
Thanks for looking at my post.
<colgroup><col span="2"></colgroup><tbody></tbody>