Time report: deleting from table
<p>Is there a way to update the table in the link below to remove the entries that have missing hours in one id but not another?</p>

<p>There are several instances where a user stopped using one id and started using another.</p>

<p>I need to see Smith's time in both 123 and 456 while excluding lines that have missing hours when there are already hours inputted into the week in another id.</p>

<p><a href="https://i.stack.imgur.com/99Ygp.png" rel="nofollow noreferrer">See table</a></p>

<p><a href="https://i.stack.imgur.com/zvl87.png" rel="nofollow noreferrer">See desired resulting table</a></p>