Condense all account notes in a report?

Condense all account notes in a report?

Hi Folks,

I am running reports for accounts and when there is multiple notes, the report creates a new line for each note under the same account name. If I have XYZ account with 7 notes, then I get 7 rows named XYZ. I'd really just like to condense all the notes under the same account into a single row. Is there a way to do so? I know I can just have a single note under account and keep adding to it, but that defeats the purpose of new notes with date stamps.

Thank you, Derek