I have 4 columns like:
<tbody>
</tbody>
I need to find count of non blank rows in Team 1, Team 2, and Team 3, but filtered by the Name and School.
The result should look like:
<tbody>
</tbody>
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> | Brittany | |||||
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody>
</tbody>
I need to find count of non blank rows in Team 1, Team 2, and Team 3, but filtered by the Name and School.
The result should look like:
Team 1 | Team 2 | Team 3 | |
Name | John | Shaun | Haley |
Mike | Divya | Brittany | |
Alex | Molly | ||
3 | 2 | 3 | |
School | ABC | DEF | |
DEF | GHI | ||
ABC | |||
2 | 3 | 0 |
<tbody>
</tbody>