Hi Friends,

I need a help from you.
I have 2 excel tables in different sheets.
1st table is customer database
2nd table is their settlement database

Customer has unique ID in customer table.
Settlement database has duplicate customer IDs.

For example

'Customer Database
XXX001 Cust Name - John

'Settlement Database
XXX001 - Sett Date 1/5/2013 amount $4000
XXX001 - Sett Date 2/7/2013 amount $4500

I want to join two these tables for pivot table reports

Please help me. Advance Thanks