I need to look up all duplicate account# (Column B)and merge all comments
(column E) into one row. I tried to use the Concatenate formula, but I could
not get it to work correctly. I was pulling comments from the row below.
Any suggestions would be great thanks.



Example:
DED222562 please provide ppd information 9/06/07 AB
DED222562 Customer will not pay 11/13/07 fer
DED222562 needed infm as to why was it ppd and a copy of debit memo