removing empty column from pivot table

[lezawang]

Hi
I followed a video on youtune and create this pivot table. I want to delete "Count of Car Make2" column, the empty column. How can I do that?
Thank you very much.

MOCK_DATA (1).csv
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Car Make	Car Color	Car VIN					Column Labels
2	03/06/2021	Buick	Violet	1GYUKKEF5AR364653					2020		2021
3	05/12/2021	Chrysler	Mauv	WVWDB7AJXEW083355				Row Labels	Count of Car Make	Count of Car Make2	Count of Car Make	Count of Car Make2
4	29/11/2020	Mercedes-Benz	Fuscia	3D4PH7FG9BT235686				Jan	5		5	0.00%
5	24/01/2021	Chevrolet	Pink	2C3CCAGGXCH195669				Feb	2		6	200.00%
6	09/02/2021	Chevrolet	Mauv	WA1MKBFP9AA446679				Mar	6		4	-33.33%
7	04/06/2020	Mazda	Teal	1N6BF0KL3FN736843				Apr	4		7	75.00%
8	12/02/2021	Mercury	Violet	3VWPG3AG9AM200846				May	5		4	-20.00%
9	16/04/2021	Chevrolet	Yellow	1N6AF0LY6EN996819				Jun	3		4	33.33%
10	03/04/2021	Ford	Blue	4JGDA0EB0FA129606				Jul	5		5	0.00%
11	12/10/2021	BMW	Pink	KMHGH4JF2BU023014				Aug	4		5	25.00%
12	06/05/2020	Volkswagen	Yellow	JTDZN3EU2E3528442				Sep	4		5	25.00%
13	22/03/2020	Chevrolet	Violet	WA1WMAFE1AD868553				Oct	4		2	-50.00%
14	07/07/2020	Chevrolet	Pink	1G6DC5EG8A0622359				Nov	5		2	-60.00%
15	02/12/2021	Mercedes-Benz	Khaki	WAUGFAFR2DA254315				Dec			4
MOCK_DATA (1)

 

[lezawang]

Sorry just to add, itis Year over Year comparsion. The video link is this

Thank you.

 

[RoryA]

Unless you're using the data model, you can't remove just the empty one of those columns - you'd have to hide it.