Hi Nitya,

Am Tue, 16 Jun 2015 02:59:00 -0700 (PDT) schrieb Nitya Satheesh:

NAme Month
a may
a may
a may
b may
b may
b may
c may
c may
a jun
a jun
a jun
b jun
b jun
b jun

copy your data to another range = Data = Remove Duplicates and create
the Pivot table with the new data range.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional