organisation summary

Hi guys,

Can anyone please help me with this task.
Basically I have a list of 800 plus organisations with different headings/columns.
In the list, there are same organisations which are listed 2 or 3 times.
What I want to do is create a summary, so all the same organisations are showing on the same row without having to manually add them on the same row as this will be time consuming

Please see an example which I have attached.

I hope to hear from you all soon.

Many thanks