title: How to merge two excel sheets by patient ID without excluding duplicate data
body: <p>I want to merge two data sheets by patient ID including all data. Is there an easy way to combine two excel sheets and create one data file in excel. 
  Sheet 1 is in the left side and sheet 2 is in the right side.</p>
  
  <p><a href="https://i.stack.imgur.com/bWrhM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bWrhM.png" alt=""></a><a href="https://i.stack.imgur.com/5udS6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5udS6.png" alt="enter image description here"></a></p>