title: Excel VBA: Copy and paste duplicate values from other cell
body: <p>I have an excel file with two columns. 
  Excel screenshot below: </p>
  
  <p><a href="https://i.stack.imgur.com/wgGdt.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wgGdt.jpg" alt="enter image description here"></a></p>
  
  <p>What I want is an Excel VBA that will read all duplicate values and if the cell beside it is blank, value from the other duplicate account will be pasted in the blank cell.
  Expected result:</p>
  
  <p><a href="https://i.stack.imgur.com/8rSeW.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8rSeW.jpg" alt="enter image description here"></a></p>
  
  <p>I'm not good with Excel VBA so I would really appreciate your help.</p>
  
  <p>Thank you!</p>