Merging duplicate entries in an index

Good Morning,

I'm working on a publication index, and I need to create an index for the entire year's publication out of the individual indices exist for each journal.

So far I managed to merge indices and sort them, but one issue remains:

Let's say the term "annual report" has been repeated in several different pages of the journal over the year:

Annual Report *E161
Annual Report *E150
Annual Report *E243, E260, E275, E284
Annual*Report *E243

(E161,E150, ... are page numbers)


I need a way to detect duplicate terms in first column, and group the page numbers like this:

Annual*Report *E161,*E150*,E243, E260, E275, E284,*E243

Thanks for your advice in advance,
K

Hi Dave,

Thank you very much! and yes, those star signs are all typos.

I've managed to follow your instructions and it worked


Thanks,
Kasra