PaulWSmith
New Member
- Joined
- May 22, 2018
- Messages
- 1
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:
[TABLE="width: 805"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]MOM[/TD]
[TD]Division[/TD]
[TD]Pts[/TD]
[TD][/TD]
[TD]MOM[/TD]
[TD]Division[/TD]
[TD]Pts[/TD]
[/TR]
[TR]
[TD]Shepherds Bush[/TD]
[TD]First Teams - Division 2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Brondesbury[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]North Middlesex[/TD]
[TD]First Teams - Division 3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]North Middlesex[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finchley[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Brondesbury[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finchley[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Highgate[/TD]
[TD]First Teams - Division 3[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
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.
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:
[TABLE="width: 805"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]MOM[/TD]
[TD]Division[/TD]
[TD]Pts[/TD]
[TD][/TD]
[TD]MOM[/TD]
[TD]Division[/TD]
[TD]Pts[/TD]
[/TR]
[TR]
[TD]Shepherds Bush[/TD]
[TD]First Teams - Division 2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Brondesbury[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]North Middlesex[/TD]
[TD]First Teams - Division 3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]North Middlesex[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finchley[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Brondesbury[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finchley[/TD]
[TD]First Teams - Premier Division[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]Highgate[/TD]
[TD]First Teams - Division 3[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
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.