title: Excel Combining/Concatenating one column based on the value of another
body: <p>I apologise if this question already exists, I searched for a while but couldn't find anything.</p>
  
  <p>I have 2 columns in Excel and I need to concatenate the values of 1 column where the values of  another are the same. As an example I have this:</p>
  
  <pre><code>A  | B
  12 | Value 1
  10 | Value 2
  13 | Value 3
  12 | Value 4
  10 | Value 5
  </code></pre>
  
  <p>And I would like to get out:</p>
  
  <pre><code>A  | B
  12 | Value 1, Value 4
  10 | Value 2, Value 5
  13 | Value 3
  </code></pre>
  
  <p>I have thousands of rows and ideally I would like it to create a new worksheet with the results and not destroy the existing sheet. There are also some blank values in column B which I would like it to ignore and not concatenate.</p>
  
  <p>Thanks in advance.</p>