Check if this helps..
... | dedup field1, field2 | stats list(field1) by field2
Hi sridamg,
try something like this:
some search | stats values(field1) by field2
see the docs for more information http://docs.splunk.com/Documentation/Splunk/6.1.3/SearchReference/CommonStatsFunctions
cheers, MuS