Excel Exporting Template

Exporting pivot matrix with template

 
  dollar_sales - sum   dollar_sales - count  
  orderYear   orderQuarter  
  customerName   productLine   productName  
2004
2005
Total
Q3
Q4
Total
Q1
Total
dollar_sales - sum
dollar_sales - count
dollar_sales - sum
dollar_sales - count
dollar_sales - sum
dollar_sales - count
dollar_sales - sum
dollar_sales - count
dollar_sales - sum
dollar_sales - count
dollar_sales - sum
dollar_sales - count
AV Stores, Co.
Classic Cars
1949 Jaguar XK 120
1952 Citroen-15CV
1957 Ford Thunderbird
1966 Shelby Cobra 427 S/C
1969 Chevrolet Camaro Z28
1969 Corvair Monza
1969 Ford Falcon
1970 Chevy Chevelle SS 454
1970 Triumph Spitfire
2001 Ferrari Enzo
2002 Chevy Corvette
Total
Ships
18th century schooner
Pont Yacht
The Mayflower
The Queen Mary
The Schooner Bluenose
The Titanic
The USS Constitution Ship
Total
Trains
1950's Chicago Surface Lines Streetcar
1962 City of Detroit Streetcar
Collectable Wooden Train
Total
Vintage Cars
18th Century Vintage Horse Carriage
1903 Ford Model A
1904 Buick Runabout
1911 Ford Town Car
1912 Ford Model T Delivery Wagon
1928 Mercedes-Benz SSK
1932 Alfa Romeo 8C2300 Spider Sport
1932 Model A Ford J-Coupe
1934 Ford V8 Coupe
1936 Mercedes Benz 500k Roadster
1936 Mercedes-Benz 500K Special Roadster
1937 Lincoln Berline
1938 Cadillac V-16 Presidential Limousine
1939 Chevrolet Deluxe Coupe
Total
Total
Alpha Cognac
Ships
Pont Yacht
The Mayflower
The Queen Mary
The Titanic
The USS Constitution Ship
Total
Total
Amica Models & Co.
Classic Cars
1952 Alpine Renault 1300
1969 Corvair Monza
1969 Ford Falcon
2001 Ferrari Enzo
Total
Ships
18th century schooner
Pont Yacht
The Mayflower
Total
Trains
Collectable Wooden Train
Total
Trucks and Buses
1940 Ford Pickup Truck
Total
Vintage Cars
18th Century Vintage Horse Carriage
1903 Ford Model A
1904 Buick Runabout
1911 Ford Town Car
1913 Ford Model T Speedster
1917 Grand Touring Sedan
1917 Maxwell Touring Car
1928 Mercedes-Benz SSK
1932 Alfa Romeo 8C2300 Spider Sport
1932 Model A Ford J-Coupe
1934 Ford V8 Coupe
1936 Chrysler Airflow
1936 Mercedes Benz 500k Roadster
1936 Mercedes-Benz 500K Special Roadster
1937 Lincoln Berline
1938 Cadillac V-16 Presidential Limousine
1939 Chevrolet Deluxe Coupe
Total
Total
Anna's Decorations, Ltd
Classic Cars
1952 Alpine Renault 1300
1962 LanciaA Delta 16V
1992 Ferrari 360 Spider red
Total
Trucks and Buses
1926 Ford Fire Engine
1940 Ford Pickup Truck
1940s Ford truck
1958 Setra Bus
1964 Mercedes Tour Bus
1996 Peterbilt 379 Stake Bed with Outrigger
Total
Vintage Cars
1913 Ford Model T Speedster
1936 Mercedes-Benz 500K Special Roadster
1937 Lincoln Berline
1938 Cadillac V-16 Presidential Limousine
1939 Cadillac Limousine
1939 Chevrolet Deluxe Coupe
Total
Total
Atelier graphique
Motorcycles
1936 Harley Davidson El Knucklehead
1996 Moto Guzzi 1100i
Total
Vintage Cars
1938 Cadillac V-16 Presidential Limousine
Total
Total
Total
-
-
3295.89
1
3295.89
1
-
-
-
-
3295.89
1
-
-
4753.76
1
4753.76
1
-
-
-
-
4753.76
1
-
-
1481.76
1
1481.76
1
-
-
-
-
1481.76
1
-
-
945.8
1
945.8
1
-
-
-
-
945.8
1
-
-
3505.95
1
3505.95
1
-
-
-
-
3505.95
1
-
-
4931.36
1
4931.36
1
-
-
-
-
4931.36
1
-
-
2906.8
1
2906.8
1
-
-
-
-
2906.8
1
-
-
1419.79
1
1419.79
1
-
-
-
-
1419.79
1
-
-
2906.97
1
2906.97
1
-
-
-
-
2906.97
1
-
-
5668.66
1
5668.66
1
-
-
-
-
5668.66
1
-
-
2921.13
1
2921.13
1
-
-
-
-
2921.13
1
-
-
34737.87
11
34737.87
11
-
-
-
-
34737.87
11
-
-
3171.73
1
3171.73
1
-
-
-
-
3171.73
1
-
-
1681.75
1
1681.75
1
-
-
-
-
1681.75
1
-
-
2797.56
1
2797.56
1
-
-
-
-
2797.56
1
-
-
2621.7
1
2621.7
1
-
-
-
-
2621.7
1
-
-
3067
1
3067
1
-
-
-
-
3067
1
-
-
3173.44
1
3173.44
1
-
-
-
-
3173.44
1
-
-
2672.88
1
2672.88
1
-
-
-
-
2672.88
1
-
-
19186.06
7
19186.06
7
-
-
-
-
19186.06
7
-
-
2772.88
1
2772.88
1
-
-
-
-
2772.88
1
-
-
1752.7
1
1752.7
1
-
-
-
-
1752.7
1
-
-
3348
1
3348
1
-
-
-
-
3348
1
-
-
7873.58
3
7873.58
3
-
-
-
-
7873.58
3
-
-
4021.2
1
4021.2
1
-
-
-
-
4021.2
1
-
-
3671.68
1
3671.68
1
-
-
-
-
3671.68
1
-
-
3320.46
1
3320.46
1
-
-
-
-
3320.46
1
-
-
2047.44
1
2047.44
1
-
-
-
-
2047.44
1
-
-
2359.72
1
2359.72
1
-
-
-
-
2359.72
1
-
-
3321.12
1
3321.12
1
-
-
-
-
3321.12
1
-
-
4601.5
1
4601.5
1
-
-
-
-
4601.5
1
-
-
4093.6
1
4093.6
1
-
-
-
-
4093.6
1
-
-
1380.34
1
1380.34
1
-
-
-
-
1380.34
1
-
-
1413.27
1
1413.27
1
-
-
-
-
1413.27
1
-
-
1382.67
1
1382.67
1
-
-
-
-
1382.67
1
-
-
4111.48
1
4111.48
1
-
-
-
-
4111.48
1
-
-
1118.26
1
1118.26
1
-
-
-
-
1118.26
1
-
-
1344.15
1
1344.15
1
-
-
-
-
1344.15
1
-
-
38186.89
14
38186.89
14
-
-
-
-
38186.89
14
-
-
99984.4
35
99984.4
35
-
-
-
-
99984.4
35
-
-
-
-
-
-
1800.64
1
1800.64
1
1800.64
1
-
-
-
-
-
-
2217.28
1
2217.28
1
2217.28
1
-
-
-
-
-
-
2895.84
1
2895.84
1
2895.84
1
-
-
-
-
-
-
4135.2
1
4135.2
1
4135.2
1
-
-
-
-
-
-
1383.36
1
1383.36
1
1383.36
1
-
-
-
-
-
-
12432.32
5
12432.32
5
12432.32
5
-
-
-
-
-
-
12432.32
5
12432.32
5
12432.32
5
6994.82
1
-
-
6994.82
1
-
-
-
-
6994.82
1
3118.32
1
-
-
3118.32
1
-
-
-
-
3118.32
1
7708.05
1
-
-
7708.05
1
-
-
-
-
7708.05
1
8602.92
1
-
-
8602.92
1
-
-
-
-
8602.92
1
26424.11
4
-
-
26424.11
4
-
-
-
-
26424.11
4
2348.43
1
-
-
2348.43
1
-
-
-
-
2348.43
1
1642.24
1
-
-
1642.24
1
-
-
-
-
1642.24
1
2260.55
1
-
-
2260.55
1
-
-
-
-
2260.55
1
6251.22
3
-
-
6251.22
3
-
-
-
-
6251.22
3
2018.72
1
-
-
2018.72
1
-
-
-
-
2018.72
1
2018.72
1
-
-
2018.72
1
-
-
-
-
2018.72
1
2352
1
-
-
2352
1
-
-
-
-
2352
1
2352
1
-
-
2352
1
-
-
-
-
2352
1
2976.27
1
-
-
2976.27
1
-
-
-
-
2976.27
1
2655.36
1
-
-
2655.36
1
-
-
-
-
2655.36
1
3569.65
1
-
-
3569.65
1
-
-
-
-
3569.65
1
1332
1
-
-
1332
1
-
-
-
-
1332
1
3774.76
1
-
-
3774.76
1
-
-
-
-
3774.76
1
4199
1
-
-
4199
1
-
-
-
-
4199
1
3373.14
1
-
-
3373.14
1
-
-
-
-
3373.14
1
3489.86
1
-
-
3489.86
1
-
-
-
-
3489.86
1
2705.85
1
-
-
2705.85
1
-
-
-
-
2705.85
1
4045.21
1
-
-
4045.21
1
-
-
-
-
4045.21
1
2336.62
1
-
-
2336.62
1
-
-
-
-
2336.62
1
1677.06
1
-
-
1677.06
1
-
-
-
-
1677.06
1
1164.57
1
-
-
1164.57
1
-
-
-
-
1164.57
1
1280.88
1
-
-
1280.88
1
-
-
-
-
1280.88
1
4366.5
1
-
-
4366.5
1
-
-
-
-
4366.5
1
1633.05
1
-
-
1633.05
1
-
-
-
-
1633.05
1
597.4
1
-
-
597.4
1
-
-
-
-
597.4
1
45177.18
17
-
-
45177.18
17
-
-
-
-
45177.18
17
82223.23
26
-
-
82223.23
26
-
-
-
-
82223.23
26
-
-
-
-
-
-
4680.24
1
4680.24
1
4680.24
1
-
-
-
-
-
-
8981.1
2
8981.1
2
8981.1
2
-
-
-
-
-
-
4526.55
1
4526.55
1
4526.55
1
-
-
-
-
-
-
18187.89
4
18187.89
4
18187.89
4
-
-
-
-
-
-
3863.64
2
3863.64
2
3863.64
2
-
-
-
-
-
-
6025.04
2
6025.04
2
6025.04
2
-
-
-
-
-
-
3054.86
1
3054.86
1
3054.86
1
-
-
-
-
-
-
10612.33
2
10612.33
2
10612.33
2
-
-
-
-
-
-
2241.14
1
2241.14
1
2241.14
1
-
-
-
-
-
-
1599.75
1
1599.75
1
1599.75
1
-
-
-
-
-
-
27396.76
9
27396.76
9
27396.76
9
-