Excel help --- wants to get rid of zero value cells : <p><a href="https://i.stack.imgur.com/TP3i5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TP3i5.png" alt="first two columns are automated data d and e columns is my requirement"></a></p>

<p>Hi i need help with this i want to get rid of all zero value cells without vba and any manual method. first two columns A and B is automated data generated by a software all i want is to show data in D and E like i showed in the example. is there any way to do it without vba and manually?</p>
