Cleansing for CRM uploads
 

I have a spreadsheet which has two columns; the first being the
Account/Company name; the second being old contact history notes. When the
second column has lots of entries the first column only shows the
Account/Company name once, leaving cells empty until a new series of contact
history notes relating to a new Account/Company begin.

Q: Excel will not allow me to merge the cells containing multiple 'Contact
History Notes' as I need to only have two corresponding columns and cells;
how can I merge all the notes in my second column to match the single
account info in the first column?