So I'm trying to figure out the best way to get a report for unique values in a VERY large table similar to the example below. Note that the values in the table are ONLY a representation so I do not need to sum or calculate anything.

I want the header and row for a specified value (looking for all instances of "1" in this example)

example.JPG

What's the best way to get this report?

I've been trying pivot table with no success. Any good examples for this anywhere?