<div>
The primary key/column would be A and B in this case. &nbsp;A and B will be the same, but column C and D changes. &nbsp;I want to remove duplicate and then just append column C and D with a comma separating them.
</div>


The primary key/column would be A and B in this case.  A and B will be the same, but column C and D changes.  I want to remove duplicate and then just append column C and D with a comma separating them.

<div>
Awesome. &nbsp;Works perfectly.
</div>


<div>
<div class="content wysiwyg-content">
I have a listing of thousands of lines that are duplicate base off some unique primary cells. &nbsp;There are some other cells that are unique. &nbsp;I would like to append/combine these cells. &nbsp;Is this possible?<br />
<br />
I am attaching an example with the raw data and final output. &nbsp;Not sure if Excel can do this or some VBA script can?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/08_w33/865890/C--Users-cchang-Documents-Example.jpg" target="_blank" title="Example (51 KB)"><img alt="Example" class="file-block lazyload" style="max-width: 538px;" data-src="https://filedb.experts-exchange.com/incoming/2014/08_w33/865890/C--Users-cchang-Documents-Example.jpg" /></a>
</div>
</div>


C--Users-cchang-Documents-Example.jpg

I have a listing of thousands of lines that are duplicate base off some unique primary cells.  There are some other cells that are unique.  I would like to append/combine these cells.  Is this possible?

I am attaching an example with the raw data and final output.  Not sure if Excel can do this or some VBA script can?



EXCEL - Merge duplicate and append unique Cells

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.