title: How to convert the cell values in comma separated value in excel?
body: <p>Can anyone help me with an excel formula that groups related rows and creates a comma separated value result.</p>
  
  <p>Original:</p>
  
  <pre><code>State   city
  WB  city1
  WB  city2
  WB  city3
  WB  city4
  WB  city5
  Kar banga
  kar Mysore
  </code></pre>
  
  <p>Expected:</p>
  
  <pre><code>State   city
  WB  ciry1,city2,city3,city4,city5
  Kar banga,Mysore
  </code></pre>