Merging in Excel

[sarasotamac]

Hi,

I was wondering if anyone could help me with something in Excel. I don't really know what I am doing in it. I have a spread sheet with lists of account numbers and notes next to them. I want to have excel combine all of the rows of notes with the same account number.

How is it done?

[soybean]

So, you have multiple rows with the same account number?  Right?  For those rows, are the notes the same, or do they vary?

[sarasotamac]

Thanks for the reply. No, the notes are different. So we need to get all of the notes combined, in one cell with the corresponding account number.

Thanks!

Mac

[soybean]

How many records/rows are in this Excel file?  I don't know of a way to automate this, and doing it manually will be a tedious procedure if you have a large number of records.

To manually do this, you could copy the notes for each account to Notepad.  Then when you have all the notes for a particular account consolidated in Notepad, copy them back to Excel.  

[sarasotamac]

Ya, I have goten to that point. I have almost 600 accounts with about 20,000 rows. Yuck. Thanks anyway!

[soybean]

I presume you're sorting those records to get all the records for a particular account listed together.  I will mention the Concatenate function, in case that might help.  If you're not familiar with it, take a look in Excel's Help.  You can also combine text from different cells by using the & symbol.  For example: A1 contains Good and B1 contains bye.  To make C1 display Goodbye, type =A1&B1 in C1.