lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
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) |