Consolidated Pivot

[sanket]

I have two or more excel sheet data with deferent row column combination & multiple duplicate entries of party – party name and month is common in thes sheets but with multiple entries of both combination , I want to consolidate this data in single pivot .

I tried doing it with make relation but excel sheet is giving multiple duplicate data err .

Is there any other way out for this ?

Sanket