google spreadsheet - list of dates associated with name -

what approach report of dates name occurs in list? can done single array formula?

example (column a , b input, columns c through g to auto-generated):

|       |   b    |   c    |   d     |    e    |    f    |    g    | +---------+--------+--------+---------+---------+---------+---------+ | episode | stars  | name   | date    | date    | date    | date    | +---------+--------+--------+---------+---------+---------+---------+ | 7/24/15 | bart   | bart   | 7/24/15 | 7/18/15 | 8/15/15 | 3/29/15 | | 8/09/15 | maggie | homer  | 1/10/15 |         |         |         | | 7/24/15 | marge  | lisa   | 7/20/15 | 6/04/15 |         |         | | 7/18/15 | bart   | maggie | 8/09/15 |         |         |         |  | 1/10/15 | homer  | marge  | 7/24/15 |         |         |         | | 8/15/15 | bart   |        |         |         |         |         | | 7/20/15 | lisa   |        |         |         |         |         |  | 6/04/15 | lisa   |        |         |         |         |         | | 3/29/15 | bart   |        |         |         |         |         |        |^^^^^^|    |      |    |      |    | (o)(o)    @      _)       | ,___|  - dude!     |   /     /___\    /     \ 

i don't think possible in single arrayformula. however, alternative try formula in cell c2:

=sort(unique(query(filter(b$2:b,len(b$2:b)))),1,1)

then try formula in cell d2 , drag down:

=transpose(query(a$2:b,"select b='"&c2&"'"))

see example sheet see working: https://goo.gl/0u41u5