Pivot Table Query - Looking for a Neat, Clean Solution

I have 2 columns of data. I need to generate a pivot table that lists all instances where a col 1 has more than 1 unique reference in col 2.

I do not want to remove duplicates as we need these later. (See attached sample sheet)

e.g. in pivot table it should show:

Col 1 Count
arrivealive.co.za 3

Then when you click on the 3 it opens sheet to show:
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za salearners.co.za
arrivealive.co.za k53.gavinhoole.ws


Col 1: Col 2:
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za getyourlearners.co.za
arrivealive.co.za salearners.co.za
arrivealive.co.za salearners.co.za
arrivealive.co.za k53.gavinhoole.ws
arrivealive.co.za k53.gavinhoole.ws
arrivealive.co.za k53.gavinhoole.ws
arrivealive.co.za k53.gavinhoole.ws
autostart.co.za salearners.co.za
autostart.co.za salearners.co.za
biketalk.co.za salearners.co.za
brainexperiment.org getyourlearners.co.za

Any help will be most appreciated!