title: Excel concatenation multiple values into a single cell based on condition
body: <h1>Hi guys I'm new to excel and i would like to concatenate the country names into a single cell separated by '/'for the particular corresponding customer as shown in the below</h1>
  
  <p>colA1 colB1</p>
  
  <p>A   India   </p>
  
  <p>A   UK  </p>
  
  <p>A   USA </p>
  
  <p>A   Japan<br>
  <strong>A India/UK/USA/Japan</strong>    </p>
  
  <p>B   India   </p>
  
  <p>B   UK  </p>
  
  <p>B   USA </p>
  
  <p>B   Japan   </p>
  
  <h1><strong>B India/UK/USA/Japan</strong></h1>
  
  <p>i am expecting the results in the above highlighted row using excel.</p>
  
  <p>Thanks for your help</p>