title: Merging Rows on a Unique Identifier without Eliminating Unique Data and Adding Values Together
body: <p>I have a large excel spreadsheet where I need to merge rows on a unique identifier. I'm trying to develop an Excel VBA macro but still lack the proficiency to tackle this. </p>
  
  <p>Here is a picture of an example of what I'm trying to do. The data including the headers are all made up for the example but what is demonstrated down below is exactly what I'm trying to do. </p>
  
  <p><strong><em>EXAMPLE:</em></strong></p>
  
  <p><strong>Before:</strong></p>
  
  <pre><code>Unique ID | Item Name | Item Description | Numbers Sold | Notes
  11111     | Cupcakes  | Red              | 10           | Good
  11111     | Cupcakes  | Red              | 15           | Testing
  11111     | Cupcakes  | Red              | 10           | Bad
  22222     | Brownies  | Brown            | 11           | Example
  22222     | Brownies  | Brown            | 11           | Example2
  22222     | Brownies  | Brown            | 26           | Example3
  </code></pre>
  
  <p><strong>After:</strong></p>
  
  <pre><code>Unique ID | Item Name | Item Description | Numbers Sold | Notes
  11111     | Cupcakes  | Red              | 35           | Good, Testing, Bad
  22222     | Brownies  | Brown            | 37           | Example, Example 2, Example 3
  </code></pre>
  
  <p>As you can see, similar data is merged together on the first 3 columns based upon the unique ID. The 4th column containing number values are added up. Any unique values in the 5th column are kept together as unique data. </p>
  
  <p>I would appreciate any help or tips anyone can give me. Thank you! </p>