Need Tool / Script / Excel Script To Sort Lists of Keywords

I want to input multiple lists of keywords and have them sorted for me:

List 1:

Audi
Mercedes
Jaguar

List 2:

Audi
Ferrari
Lamborghini

Output:

Audi (2)
Mercedes
Jaguar
Ferrari
Lamborghini

As you can see in the output if the lists have any duplicate keywords it will add a count (2) each list will keep adding new keywords and stacking the count if there are any duplicates.

How can I do this?

You can use mysql with query insert ignore on duplicate key update counter=counter+1

Or in excel use: =SUMPRODUCT((A1:A100<>"")/COUNTIF(A1:A100,A1:A100&"")) than sort by counter and remove duplicates