Hoping someone can help me with this. I have a list of 160 addresses and
columns that represent occurance of issues at these addresses. I want to
create a pivot that only shows the sites if there the value is greater than 0.

An example of the data in my spreadsheet

Site Issue 1 Issue 2 Issue3
A 1 0 0
B 0 0 0
C 0 1 1

I only want sites A and C to appear in the pivot and then sum the number of
occurances by Issue.