title: Consolidate Duplicate Rows - VBA?
body: <p>I have a spreadsheet as below:
  <a href="https://docs.google.com/spreadsheet/ccc?key=0AtJf3QxjsYafdHNpWnZqc3p3NnpydXEtS0lVQWpKdVE#gid=0" rel="nofollow noreferrer">combine duplicates</a></p>
  
  <p>I can merge the duplicates by using the script <a href="https://stackoverflow.com/questions/10612386/excel-combine-multiple-columns-to-a-single-column">here</a>. </p>
  
  <p>However, I have no idea to add the column A  to the merged column (K) . Any help appreciated!</p>
  
  <p>Thanks</p>