title: Excel concatenate the column based on other column
body: <pre><code> I have data in excel like this 
  
     A         B      C
  
     p1       ABC    2
     p2wt     ABC    3
     p3       EFG    1
     p3wtke   EFG    1
     p9r      EFG    2
  </code></pre>
  
  <p>I'm trying to sum up C column if B column has same data and concatenate A column data. And data looks  like</p>
  
  <pre><code>    A             B       C
  
     p1-p2wt       ABC     5      
     p3-p3wtke-p9r EFG     4
  </code></pre>
  
  <p>I tried using <code>=SUMIFS(C1:C5,A1:A9,B1)</code>  but it is giving #value, and how do i concate A? I tried <a href="https://stackoverflow.com/questions/11195148/excel-concatenate">Excel concatenate</a>, but is A2>A1 in this link is for number fields? </p>