title: Excel: Copy value down a column until first blank cell in another column?
body: <p>I'm hoping to find a way to copy a cell value down Column B until the first blank cell in Column E. What I have is basically this:</p>
  
  <p><img src="https://i.stack.imgur.com/PCU8y.jpg" alt="enter image description here"></p>
  
  <p>But what I would like to have happen automatically is this:</p>
  
  <p><img src="https://i.stack.imgur.com/46UNB.jpg" alt="enter image description here"></p>
  
  <p>Is there a way to make the product name copy down Column B automatically whenever a new ingredient is added in Column E, and then start over with a new product name when a new product is added (after a blank row).</p>