title: Merge the cell values if duplicates exist
body: <p>I want to merge the values in column B if Duplicates exist in Column A</p>
  
  <pre><code>   A    B
    123   A
    123   B
    123   C
    456   D
    456   E
    789   F
  </code></pre>
  
  <p>My output should look like this</p>
  
  <pre><code>  A     B
   123    A B C
   456    D E
   789    F
  </code></pre>
  
  <p>I have a large amount of data and it is hard to do it manually ,So u guys have any idea to do it in macros in Excel?</p>
  
  <p>Any help will be appreciated..Thanks in Advance</p>