Creating A Pivot Table from Two Identical Ranges

[PaulWSmith]

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 created, rather than having the column names as options in the PivotTable Fields dialog, all I get is Row, Column and Value ????

My data:

MOM	Division	Pts		MOM	Division	Pts
Shepherds Bush	First Teams - Division 2	2		Brondesbury	First Teams - Premier Division	1
North Middlesex	First Teams - Division 3	2		North Middlesex	First Teams - Premier Division	1
Finchley	First Teams - Premier Division	2		Brondesbury	First Teams - Premier Division	1
Finchley	First Teams - Premier Division	2		Highgate	First Teams - Division 3	1

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

What am I doing wrong, surely this is an easy task? I do not want to write lots of VBA which every time the data changes has to build a single list just so I can pivot it easily. It seems i should be able to pivot multiple ranges so why can I not get it to work, what am I doing wrong.