Donovan
Your example shows 2 cells in Column 1 which are the same, and then you
concatenate the corresponding 2 cells in Column 2. Can your data have more
than 2 cells in Column 1 with the same value? If so, do you want to
concatenate all the corresponding cells in Column 2?
HTH Otto
"Donovan Panone" <Donovan wrote in message
...
I'm trying to combine rows of data and I need a certain column to
concatenate
only if it is in a group of rows that have duplicate information in
another
column.

Example:

Before...

Column 1 Column 2
X A
X B
Y C
Y D

Desired After...

Column 1 Column 2
X AB
Y CD

This is for a spreadsheet with thousands of rows

Any suggestions?