pivot table replace one subtotal with another one

[Ethel]

Hello! Could you please help me to solve this problem?

I have a pivot table with Category1 and Category2. I need to "Replace" numbers in category1 with numbers from category2 to get result like in the second table. Please help! 

Thanks a lot in advance!!!

	Nov				Dec
	Group1		Group2		Group3		Group4
	Subgroup1	Subgroup2	Subgroup3	Subgroup4	Subgroup5	Subgroup6	Subgroup7	Subgroup8
Category1	1	2	3	4	5	6	7	8
SubCat1	0.5	1.5	2	2	2	3	3	2
SubCat2	0.5	0.5	1	2	3	3	4	6
Category2	9	10	11	12	13	14	15	16
SubCat2	9	10	11	12	13	14	15	16

	Nov				Dec
	Group1		Group2		Group3		Group4
	Subgroup1	Subgroup2	Subgroup3	Subgroup4	Subgroup5	Subgroup6	Subgroup7	Subgroup8
Category1	9	10	11	12	13	14	15	16
SubCat1	0.5	1.5	2	2	2	3	3	2
SubCat2	0.5	0.5	1	2	3	3	4	6
Category2	9	10	11	12	13	14	15	16
SubCat2	9	10	11	12	13	14	15	16

[Ethel]

Now I'm loading data with SQL. I'm open to different solutions (making changes in code and formulas in qlik sense)

Thanks a lot in advance!