unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hi Guys,
How can I insert a blank row if the entire row has zero ?
Before:
<tbody>
</tbody>
After:
<tbody>
</tbody>
Thanks in advance for the help.
How can I insert a blank row if the entire row has zero ?
Before:
Name | Track1 | Track2 | Track3 | Track4 |
Ben | 1 | 1 | 1 | 2 |
Sam | 3 | 4 | 5 | 6 |
Anna | 1 | 0 | 5 | 9 |
Ted | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
After:
Name | Track1 | Track2 | Track3 | Track4 |
Sam | 3 | 4 | 5 | 6 |
Ben | 1 | 1 | 1 | 2 |
Anna | 1 | 0 | 5 | 9 |
ZEROES | ||||
Ted | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
Thanks in advance for the help.