title: Return value, if blank then return value of another cell if another cell is blank then return value from third cell
body: <p>If Cherry has value then keep it and delete/hide the other ones in that row, from picture the red ones should be deleted/hidden and the black ones should be keept. Obs in reality there is no color difference this is only for explenation. so in this case data cell D2 is staying and data on C2,B2 and A2 are removing/hiding. And if the data on D2 whas missing then C2 under would be staying, B2 and A2 whas removing/hiding and so on... if only Apple have data for some cell like A23 then that will be staying and not removed/hide, and of course B23,C23 and D23 would in that case be empty <strong>How can I implement this logic in VBA or Excel formula?, Thanks!</strong>]</p>
  
  <p><a href="https://i.stack.imgur.com/cMhrG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cMhrG.png" alt="Excel sheet"></a></p>