Google-sheets – How to agglomerate similar rows in a pivot sheet

The FILTER command does this nicely. Suppose this is your table.

       A         B       C
1    Beer    Brewery    Rating
2    abc        QQ      1
3    qwe        WW      3
4    wer        EE      5
5    ert        WW      2
6    dfg        QQ      4
7    sdf        WW      3

Then add

9   Brewery  MaxRating    Favorites
10   WW                

where

B10 = MAX(FILTER(C2:C7, B2:B7=A10) 

which find the best rating for the brewery listed in A10; and

C10 = JOIN(", ", FILTER(A2:A7, B2:B7=A10, C2:C7=B10)) 

which finds all beers from that brewery with the maximal rating. Result:

9   Brewery  MaxRating    Favorites
10   WW          3         qwe, sdf

Phew that actually took me a while to work out. Your formula in cell C9 is:

=if(weekday(A9)=7,SUM(INDIRECT("R[-6]C[-1]",FALSE):INDIRECT("RC[-1]",FALSE)),"")

You can copy that all the way up/down column C.

You end up with this:

A          |   B   |    C
Date       | value | weekly total
---------------------------------
2016/08/28 |   5   |
2016/08/29 |       |
2016/08/30 |   5   |
2016/08/31 |   5   |
2016/09/01 |   5   |
2016/09/02 |       |
2016/09/03 |       |    20
2016/09/04 |   4   |
2016/09/05 |   3   |
2016/09/06 |   6   |
2016/09/07 |       |
2016/09/08 |       |
2016/09/09 |       |
2016/09/10 |       |    13
2016/09/11 |       |
2016/09/12 |       |
2016/09/13 |       |
2016/09/14 |   4   |
2016/09/15 |   3   |
2016/09/16 |   1   |
2016/09/17 |       |    8
...etc.