Group and Joining cells vertically?

[Zeldaa]

Hi all,

I was hoping someone could offer me a bit of help please.

In Column A I have company Names, in Column B I have text notes.

Would it be possible to group all notes for the same company? Not only this but each note I would like on a new line so the same cell but a new line.

Usually I would just do =B1&B2&B3 for each company but this will join everything horizontal and not vertically, also there are over 15,000 records so this will just take too long.

Thanks

 

[Andrew Poulsom]

Have you tried a pivot table? You will have to put something like Count of Company in the Data area.

 

[Zeldaa]

Will take a look