Delete duplicate data column A and merge data in colum B into single cell

**GAIMoore** · 02-19-2013, 03:43 PM

I have a set of data (around 700 rows) that contains duplicate values in column A. The data in column B needs to be merged and the duplicates need to be deleted. I have some VBA that I found that finds the duplicates and deletes them, but it does not merge the data in column B so I am losing the data when I run it. I am attaching an example of the data I have, as well as the format it should be similar to after deleting the duplicates.

Please Login or Register  to view this content.

**AB33** · 02-19-2013, 03:52 PM

Please Login or Register  to view this content.

**mike7952** · 02-19-2013, 04:00 PM

This should do it

Please Login or Register  to view this content.

**GAIMoore** · 02-19-2013, 04:17 PM

Thank you. That is exactly what I needed! Very quick response too.

Edit- Both of these responses do exactly what I need, but the top one adds the new data below the original data and the second response overwrites the original data. It is nice to have the option to overwrite or not. Thank you both for the help.