title: Excel row aggregation by index
body: <p>Need to group rows with using an index and at the same time adding a numerical column and joining a text with a dash character. I'll go straight to an example to save on words</p>
  
  <p>What I have:</p>
  
  <pre>
  Index   Value   Text
  A        10    Text1
  A        10    Text2
  B        20    Text3
  C        30    Text4
  B        20    Text5
  B        5     Text6</pre>
  
  <p>What is needed:</p>
  
  <pre>
  Index   Value   Text
  A        20     Text1-Text2
  B        45     Text3-Text5-Text6
  C        30     Text4</pre>