title: How to join two lists on excel or google sheets
body: <p>I have two lists that i need joined. I need list b2 to join to list a2 within c2.</p>
  
  <p>For example:</p>
  
  <p><a href="https://i.stack.imgur.com/OXQ3H.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OXQ3H.png" alt="enter image description here"></a></p>
  
  <p>Now Ive found many "answers" for this question however they all give me the same wrong result. </p>
  
  <p>The incorrect result is: </p>
  
  <p><a href="https://i.stack.imgur.com/6Yv18.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6Yv18.png" alt="enter image description here"></a></p>
  
  <p>Sites giving these incorrect results:</p>
  
  <p><a href="https://www.get-digital-help.com/merge-two-columns-into-one-list-in-excel/" rel="nofollow noreferrer">https://www.get-digital-help.com/merge-two-columns-into-one-list-in-excel/</a></p>