-select your source table
-Goto- DataSubtotals
"at each change in"-selectcol"a"
"use function" - select'sum"
-click"ok"

you will get your list!

-via135



shrutikhurana Wrote:
Somebody pls guide me regarding how to use pivot table in this case to
get a final worksheet with no repetitive entries of column 1, and the
total of the repetitive entries in column 2 for each entry of column 1


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=509408