title: EXCEL: Merge Multiple Rows Macro
body: <p>I need a MACRO that looks at all instances of COL A and combines all values of COL B into one row, while deleting the duplicates in the process. Adding a comma is a plus. </p>
  
  <p>I don't know any VBA, but if someone is kind enough to explain, I would love to learn. This isn't the first VBA solution I've needed. Thanks!</p>
  
  <p>Example of what I need:</p>
  
  <pre><code>COL A    COL B 
  100 ---- PC 245
  100 ---- PC 246
  100 ---- PC 247
  101 ---- PC 245
  101 ---- PC 246
  101 ---- PC 247
  </code></pre>
  
  <p><strong>INTO</strong></p>
  
  <pre><code>COL A    COL B 
  100 ---- PC 245, PC 246, PC 247
  101 ---- PC 245, PC 246, PC 247
  </code></pre>
  
  <p>This data is going into a map, so I need it concatenated for the tooltip text. Any help is appreciated. Thanks! </p>
  
  <p><em><strong>PS: What I need is a MACRO. What I don't need is a PIVOT TABLE.</em></strong> </p>