LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"