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!
Bookmarks