title: Spread values across rows Excel
body: <p>I have two tables (one for purchase order and the other for the invoice) and I want to distribute the quantity from the invoice table to the purchase order invoice quantity column but I want to match the exact quantity from the purchase order quantity.</p>
  
  <p>Here is how the table looks now</p>
  
  <p><a href="https://i.stack.imgur.com/ZwghO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZwghO.jpg" alt="Here is how the table looks now"></a></p>
  
  <p>And this is how I want it to look:</p>
  
  <p><a href="https://i.stack.imgur.com/VBvJ1.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VBvJ1.jpg" alt="enter image description here"></a></p>
  
  <p>How do I manage to do that? Thanks!</p>
  
  <p>Here is the excel attachment file:
  <a href="http://cloud.aplicabil.ro/index.php/s/8SGuTjFUXfQ1zD6" rel="nofollow noreferrer">Book1.xlsx</a></p>
  
  <p>Update:
  Is it possible to do that for multiple codes?</p>
  
  <p><a href="https://i.stack.imgur.com/fI46x.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fI46x.jpg" alt="enter image description here"></a></p>