title: Copy pasting repeated values in a column of a large excel file
body: <p>I'm stuck on a problem and would love some help.</p>
  
  <p>Here is what I'm working with now:</p>
  
  <p><img src="https://i.stack.imgur.com/uEQEt.png" alt="enter image description here"></p>
  
  <p>What I'd like is for column B,C, &amp; D to copy in the blank rows below it until it reaches a new client like so:</p>
  
  <p><img src="https://i.stack.imgur.com/tRI0E.png" alt="enter image description here"></p>
  
  <p>Any and all help is very much appreciated.</p>
  
  <p>Thanks</p>