Complex replicate co-sorting of 2 columns

[stonegwene]

First time posting here. I couldn't find a solution to accomodate my request - please help!

I have a long list (~1000) rows of data stored in two columns (say, A1 and A2). A1 contains a title (of which there are 7 unique titles) and A2 contains one word text derived from that title. The data is sorted alphabetically by the "one word text derivations" (column A2), and A1 is cosorted. There are duplicates/triplicates...7-plicates of the "one word text derivations" in column A2.

I need to somehow count how many "---plicates" there are of the "one word text derivations" in column A2 and, in an adjacent cell, write the "title" 's that correspond to the "one word text derivation" row.

For example,
Titles(a,b,c,d,e,f,g)
One-word-text-derivations(cake,mouse)

A1 A2
a cake
b cake
c cake
d cake
e cake
f cake
g cake
c mouse
g mouse

I need in an adjacent column, to have the result of how many times "cake" and "mouse" is replicated and the corresponding title ("a,b,c,d,e,f,g").

Result:

One-word text derivation Times Replicated Tittle
cake 7 a,b,c,d,e,f,g
mouse 2 c,g
.
.
.
.
.
.
etc

Thank you!