Consolidating columns and listing separate individual entries in a pivot talble

I currently have a dataset of houses, the Census block group they are in, and the year the house was built. There are a lot of empty (or "0") or entries for year built, and I want to identify all block groups where over 20% of the houses have a year built value of "0" or NA.

In other words my data currently looks like this:

PROPERTY1.png

And I want it to look like this:

PROPERTY2.png

That way, I can count the number and percentage of "0" entries for each block group.

Is there a way to do this with a pivot table? I have been unable to figure it out.

Any help would be appreciated.

Hi,

Try this one.

Basseparate individual entries in a pivot table.xlsx

That worked.

Thanks!