View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Calla212
 
Posts: n/a
Default Identify duplicate coloum A cells, and merge their row and text in

I have exported data from a database into a delimited CSV. file and opened
it in excel.

The database has a field where you can enter a description for an item. It
appears that if the description has a return or is over 32 characters it
creates a new field. On the worksheet you will see duplicate cells in column
A (barcode #'s) with different descriptions in column B.

This makes sorting the worksheet very difficult and almost impossible for
reporting or mantainancing to import back into the database.

Is there a way to identify all the duplicate cell A'S and then have their
corresponding cell B's merge and still retain their text?