I am using Excel 365, and for the life of me I cannot get to produce a Pivot table from two ranges. Each range has three columns, with the same headings and the same data formats.
I am calling up the PivotTable wizard, selecting the Multiple consolidation ranges, but when the pivot table is...