I often need to merge multiple occurences of data (tax addresses & tax names) and to sum or count the values associated with each invividual instance (i.e number of units per tax address). Data can often be thousands of rows and varies every time. I would like to keep all of the associated information with each entry for mailing purposes. I saw this link...
http://www.ozgrid.com/forum/showthread.php?t=83101

However, the VBA macro, when run, only keeps my tax address an the associated sum. Please let me know if there is a way to alter the code to make this possible. I will attach the file I am working with....