Pivot Table; Consolidate filed values

[DRSteele]

Can someone please help me?

The Excel Table T_Scr contains scores for teams as visitor and as host. There are 30 teams with 82 games per team.

	A	B	C	D	E	F	G	H
1	Gm	Date	Visitor	Host	Column1	VScr	HScr
2	1	10/12/2016	St. Louis	Chicago		5	2
3	2	10/12/2016	Calgary	Edmonton		4	7
4	3	10/12/2016	Toronto	Ottawa		4	5
5	4	10/12/2016	Los Angeles	San Jose		1	2
6	5	10/13/2016	Montréal	Buffalo		4	1
7	6	10/13/2016	Boston	Columbus		6	3
8	etc
9

<tbody>
</tbody>

Sheet59​

I would like to create a pivot table that shows the count of the number of games in total that each team scored (see HScr and VScr) the various number of goals. I'm able to create two PTs, one that uses Visitor as Rows in PT Fields (like below) and one that uses Host as Rows in PT Fields, but I can't figure out how to consolidate the two PTs or their ranges.

	A	B	C	D	E	F	G	H	I	J	K
2	Count of VScr	VScr
3	Visitor	0	1	2	3	4	5	6	7	Vis
4	Anaheim	1	2	5	4	2				14
5	Arizona	1	4	5	1	2	1			14
6	Boston	1	3	7		2		1		14
7	Buffalo	1	3	4	3		1	1		13
8	Calgary	1	5	4	4	2				16

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

scoring​