Complex replicate co-sorting of 2 columns

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!

Hi stonegwene, it would probably be best if you upload a mock workbook containing some data and your desired outcome.

Hi stonegwene,
welcome to the forum

You could use a loop

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save