table with sparce data

I have data like this

Name Value
---- ------

a001         0
a002         0
a003         0
a004         0
a005         2
a006         0
a007         0
a010         0
a011         3
a017         0

and I want a report where sparcely populated frequency is compressed like this

Min Value Frequency
Name
---- ------ -----------

a001         0      4
a023         5      1
a006         0      3
a011         3      1

Any simple analytical solution? Received on Fri Aug 22 2003 - 13:34:36 CDT