Pivot Table to find Duplicates

Hi,

I have a huge database, I want to find the duplicates from Column D (type characters/names) along with data from Column F & H.

How to create a pivot table report of duplicates and data of column F & H. Sample data file attached.

Thanks.

Quote from Carim

Once you have tested the Pivot Table ... feel free to share your comments ...

Thanks, it's simple and result oriented.

Thankyou.