Sorry for the late response. I tried using a pivot table, but the problem is some of the values are below threshold (i.e written as <0.02) and the pivot tables keep returning them as 0 (which I don't want). Is there a way to get it to return the proper value? That would fix my problem...

If not I'll put together a dummy file to upload here.