Trying to consolidate pivot reports from two documents - they both have the
same sort of data in and headings.

Have managed to consolidate into 1 report however instead of showing the
headings in the pivot report it shows just Row and Column and lumps all the
data from different columns into the data area.