Pivot The Excel Way!

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Movie	LeadStudio	RottenTomatoes	AudienceScore	Story	Genre	TheatersOpenWeek	OpeningWeekend	BOAvgOpenWeekend	DomesticGross	ForeignGross	WorldGross	Budget	Profitability	OpenProfit	Year
2	Spider-Man 3	Sony	61	54	Metamorphosis	Action	4252	151.1	35540	336.53	554.34	890.87	258	345.3	58.57	2007
3	Shrek the Third	Paramount	42	57	Quest	Animation	4122	121.6	29507	322.72	476.24	798.96	160	499.35	76	2007
4	Transformers	Paramount	57	89	Monster Force	Action	4011	70.5	17577	319.25	390.46	709.71	150	473.14	47	2007
5	Pirates of the Caribbean: At World's End	Disney	45	74	Rescue	Action	4362	114.7	26302	309.42	654	963.42	300	321.14	38.23	2007
6	Harry Potter and the Order of the Phoenix	Warner Bros	78	82	Quest	Adventure	4285	77.1	17998	292	647.88	939.89	150	626.59	51.4	2007
7	I Am Legend	Warner Bros	69	69	Quest	Thriller	3606	77.2	21411	256.39	328.96	585.35	150	390.23	51.47	2007
8	The Bourne Ultimatum	Universal	93	91	Pursuit	Thriller	3660	69.3	18929	227.47	215.35	442.82	110	402.57	63	2007
9	National Treasure: Book of Secrets	Disney	31	72	The Riddle	Thriller	3832	44.8	11686	219.96	237.4	457.36	130	351.82	34.46	2007
10	Alvin and the Chipmunks	Fox	26	73	Comedy	Animation	3475	44.3	12750	217.33	144.01	361.34	70	516.19	63.29	2007
11	300	Warner Bros	60	90	Sacrifice	Action	3103	70.9	22844	210.61	245.45	456.07	65	701.64	109.08	2007
12	Ratatouille	Disney	97	84	Transformation	Animation	3940	47	11935	206.45	417.28	623.72	150	415.81	31.33	2007
13	The Simpsons Movie	Fox	90	78	Maturation	Comedy	3922	74	18877	183.14	343.94	527.07	75	702.76	98.67	2007
14	Wild Hogs	Disney	14	72	Transformation	Comedy	3287	39.7	12077	168.27	85.35	253.62	90	281.8	44.11	2007
15	Knocked Up	Universal	91	83	Love	Comedy	2871	30.7	10690	148.77	70.31	219.08	33	663.86	93.03	2007
16	Juno	Fox	94	89	Maturation	Comedy	1019	10.6	10436	143.5	87.92	231.41	7.5	3085.48	141.33	2007
17	Rush Hour 3	Warner Bros	20	68	Rescue	Action	3778	49.1	12996	140.13	117.9	258.02	140	184.3	35.07	2007
18	Live Free or Die Hard	Fox	79	86	Rescue	Action	3408	33.4	9791	134.53	249	383.53	110	348.66	30.36	2007
19	Fantastic Four: Rise of the Silver Surfer	Fox	35	55	Monster Force	Action	3959	58	14663	131.92	157.13	289.05	130	222.34	44.62	2007
20	American Gangster	Universal	79	87	pursuit	Thriller	3054	43.6	14264	130.16	136.3	266.46	100	266.46	43.6	2007
21	Enchanted	Disney	93	80	Love	Comedy	3730	34.4	9233	127.81	212.68	340.49	85	400.57	40.47	2007
22	Bee Movie	Paramount	52	57	Journey and Return	Animation	3928	38	9679	126.63	160.96	287.59	150	191.73	25.33	2007
23	Superbad	Sony	88	87	Comedy	Comedy	2948	33	11211	121.46	48.41	169.87	20	849.36	165	2007
24	I Now Pronounce You Chuck and Larry	Universal	13	73	Comedy	Comedy	3495	34.2	9795	120.06	66.01	186.07	85	218.91	40.24	2007
25	Hairspray	Warner Bros	92	84	Underdog	Musical	3121	27.5	8803	118.87	83.68	202.55	75	270.06	36.67	2007
26	Blades of Glory	Paramount	69	66	Rivalry	Comedy	3372	33	9790	118.59	27.11	145.71	61	238.87	54.1	2007
27	Ocean's 13	Warner Bros	70	74	Revenge	Thriller	3565	36.1	10135	117.15	194.16	311.31	85	366.25	42.47	2007
28	Ghost Rider	Sony	28	56	Monster Force	Action	3619	45.3	12541	115.8	112.94	228.74	110	207.94	41.18	2007
29	Evan Almighty	Universal	23	56	Comedy	Comedy	3604	31.2	8654	100.46	72.96	173.42	175	99.1	17.83	2007
30	Meet the Robinsons	Disney	66	75	Quest	Animation	3413	25.1	7361	97.82	71.51	169.33	100	169.33	25.1	2007
31	Norbit	Paramount	9	56	Comedy	Comedy	3136	34.2	10904	95.67	63.64	159.31	60	265.52	57	2007
32	The Bucket List	Warner Bros	41	81	discovery	Drama	2911	19.4	6661	93.47	81.91	175.37	45	389.72	43.11	2007
33	The Game Plan	Disney	27	75	Discovery	Comedy	3103	22.9	7396	90.65	57.23	147.88	22	672.18	104.09	2007
34	Beowulf	Paramount	71	52	Journey and Return	Action	3153	27.5	8726	82.28	114.11	196.39	150	130.93	18.33	2007
35	Disturbia	Paramount	67	75	Pursuit	Thriller	2925	22.2	7598	80.21	37.55	117.76	20	588.79	111	2007
36	No Country for Old Men	Paramount	95	84	Pursuit	Drama	860	7.8	9042	74.28	97.34	171.63	25	686.5	31.2	2007
37	The Golden Compass	Warner Bros	42	55	Rescue	Action	3528	25.7	7308	70.11	302.13	372.23	180	206.8	14.28	2007
38	Charlie Wilson's War	Universal	82	73	Discovery	Biography	2575	9.6	3750	66.66	52.34	119	75	158.67	12.8	2007
39	Saw IV	Independent	18	70	Escape	Horror	3183	31.7	9976	63.3	76.05	139.35	10	1393.52	317	2007
40	Stomp the Yard	Independent	27	83	Maturation	Musical	2051	21.9	10645	61.36	14.15	75.51	14	539.36	156.43	2007
41	Surf's Up	Sony	78	64	Discovery	Animation	3528	17.6	5000	58.87	90.18	149.04	85	175.34	20.71	2007
42	Halloween	Weinstein	26	64	Pursuit	Horror	3472	26.4	7592	58.27	21.98	80.25	20	401.27	132	2007
43	Tyler Perry's Why Did I get Married	Independent	46	47	Love	Romance	2011	21.4	10618	55.2	0.66	55.86	15	372.41	142.67	2007
44	TMNT		33	63	Monster Force	Action	3110	24.3	7799	54.15	41.46	95.61	35	273.17	69.43	2007
45	P.S. I Love You	Independent	21	82	Love	Romance	2454	6.5	2641	53.7	103.14	156.83	30	522.78	21.67	2007
46	3:10 to Yuma	Lionsgate	88	85	sacrifice	Adventure	2652	14	5292	53.61	16.41	70.02	48	145.86	29.17	2007
47	Sweeney Todd: The Demon Barber of Fleet Street	Warner Bros	86	81	Revenge	Musical	1249	9.3	7446	52.9	99.63	152.52	50	305.05	18.6	2007
48	Music and Lyrics	Warner Bros	63	70	Love	Romance		13.6		50.57	95.32	145.9	40	364.74	34	2007
49	Michael Clayton	Independent	90	72	Transformation	Thriller	2511	10.4	4131	49.03	43.96	92.99	25	371.96	41.6	2007
50	Premonition	Sony	8	55	The Riddle	Drama	2831	17.6	6202	47.85	36.29	84.15	20	420.73	88	2007
51	The Kingdom		52	78	Quest	Action	2793	17.1	6135	47.54	39.12	86.66	80	108.32	21.38	2007
52	Shooter	Paramount	47	82	Pursuit	Action	2806	14.5	5175	47	48.69	95.7	61	156.88	23.77	2007
53	License to Wed	Warner Bros	8	55	Love	Comedy	2604	10.4	4002	43.8	25.51	69.31	35	198.02	29.71	2007
54	No Reservations		39	64	Love	Comedy	2425	11.7	4826	43.11	49.49	92.6	28	330.71	41.79	2007
55	Alien vs. Predator -- Requiem	Fox	14	37	Monster Force	Horror	2611	10	3853	41.8	87.09	128.88	40	322.21	25	2007
56	There Will Be Blood	Paramount	91	84	Wretched Excess	Drama	885	4.9	5502	40.22	35.96	76.18	25	304.72	19.6	2007
57	Epic Movie	Independent	2	38	Comedy	Comedy	2801	18.6	6644	39.74	47.13	86.87	20	434.33	93	2007
58	Hitman	Fox	15	61	Quest	Action	2458	13.2	5362	39.69	60.28	99.97	17.5	571.23	75.43	2007
59	30 Days of Night	Independent	50	57	Monster Force	Horror	2855	15.6	5587	39.57	35.94	75.5	32	235.95	48.75	2007
60	Stardust	Paramount	76	86	Quest	Adventure	2540	9.16	3610	38.63	96.93	135.56	70	193.66	13.09	2007
61	The Brave One		43	65	Rivalry	Action	2755	13.5	4889	36.79	32.99	69.79	70	99.69	19.29	2007
62	The Heartbreak Kid	Paramount	30	41	Love	Comedy	3229	14	4342	36.79	90.98	127.77	60	212.94	23.33	2007
63	Smokin' Aces	Universal	27	64	Pursuit	Action	2218	14.6	6599	35.79	21.32	57.1	17	335.9	85.88	2007
64	Good Luck Chuck	Lionsgate	3	61	Love	Comedy	2612	13.7	5226	35.02	24.17	59.19	25	236.76	54.8	2007
65	Zodiac	Paramount	89	73	Pursuit	Thriller	2362	13.4	5671	33.08	51.71	84.79	65	130.44	20.62	2007
66	Mr. Magorium's Wonder Emporium	Independent	36	56	Transformation	Fantasy	3164	9.63	3043	32.06	37.41	69.47	25	277.9	38.52	2007
67	We Own the Night	Sony	55	63	Sacrifice	Drama	2362	10.8	4583	28.56	26.36	54.93	21	261.55	51.43	2007
68	Mr. Brooks	MGM	56	75	Temptation	Thriller	2453	10	4083	28.55	19.57	48.12	20	240.61	50	2007
69	The ny Diaries	Weinstein	33	52	Discovery	Comedy	2629	7.5	2845	25.93	21.81	47.74	20	238.69	37.5	2007
70	cy Drew	Independent	49	61	The Riddle	Thriller	2612	6.9	2615	25.61	5.05	30.67	20	153.33	34.5	2007
71	The Mist	Weinstein	72	64	Monster Force	Horror	2423	8.9	3686	25.59	31.7	57.29	18	318.29	49.44	2007
72	The Reaping		9	53	Quest	Horror	2603	10	3851	25.13	37.64	62.77	40	156.93	25	2007
73	Grindhouse	Weinstein	82	86	pursuit	Action	2624	11.6	4419	25.04	0.38	25.42	53	47.96	21.89	2007
74	Sicko	Weinstein	93	87	quest	Documentary	702	3.6	5128	24.54	11.55	36.09	9	400.98	40	2007
75	Across the Universe	Independent	54	84	Love	Romance	954	3.8	4009	24.34	5.02	29.37	45	65.26	8.44	2007
76	The Hills Have Eyes 2	Independent	11	50	Monster Force	Horror	2447	9.7	3958	20.8	16.66	37.47	15	249.77	64.67	2007
77	Vacancy	Sony	55	46	Pursuit	Comedy	2551	7.6	2980	19.36	15.94	35.3	19	185.79	40	2007
78	Waitress	Independent	89	67	Love	Romance	605	2	3327	19.07	3.1	22.18	2	1108.9	100	2007
79	Into the Wild	Paramount	82	90	quest	Drama	658	2.1	3249	18.35	37.9	56.25	15	375.03	14	2007
80	Walk Hard: The Dewey Cox Story	Sony	75	55	Comedy	Comedy	2650	4.1	1575	18.32	2.26	20.58	35	58.79	11.71	2007
81	Next	Paramount	29	59	Pursuit	Thriller	2725	7.1	2617	18.21	57.86	76.07	70	108.67	10.14	2007
82	Hostel: Part II	Lionsgate	44	45	Escape	Horror	2350	8.2	3490	17.61	18.01	35.62	10	356.19	82	2007
83	The Kite Runner	Paramount	66	85	Maturation	Drama	715	1.6	2243	15.8	57.48	73.28	20	366.38	8	2007
84	Happily N'Ever After	Lionsgate	4	43	Maturation	Animation	2381	6.6	2775	15.59	22.5	38.09	47	81.03	14.04	2007
85	The Invasion	Warner Bros	19	43	Monster Force	Thriller	2776	5.6	2143	15.07	25.1	40.17	80	50.21	7	2007
86	Lions for Lambs	Independent	27	48	Quest	Drama	2215	6.7	3025	15	48.21	63.22	35	180.61	19.14	2007
87	Daddy Day Camp	Sony	1	63	Comedy	Comedy	2332	3.4	1459	13.24	4.96	18.2	6	303.28	56.67	2007
88	Shoot 'Em Up	Warner Bros	67	66	Pursuit	Action	2108	5.7	2711	12.81	14.01	26.82	39	68.77	14.62	2007
89	The Darjeeling Limited	Fox	67	79	Journey and Return	Drama	698	1.8	2523	11.9	23.18	35.08	17.5	200.45	10.29	2007
90	In the Land of Women	Warner Bros	43	72	Transformation	Comedy	2155	4.7	2186	11.05	6.51	17.56	10	175.61	47	2007
91	Dragon Wars (aka D-War)	Mediaplex	27	44	Monster Force	Action	2277	5	2213	10.98	64.13	75.11	75	100.14	6.67	2007
92	Pathfinder: Legend of the Ghost Warrior		11	41	Rescue	Action	1720	5	2907	10.23	20.59	30.82	26	118.55	19.23	2007
93	The Dark Knight	Warner Bros	94	96	Revenge	Thriller	4366	158.4	36283	534.86	469.7	1004.56	185	543	85.62	2008
94	Iron Man	Paramount	94	91	Metamorphosis	Action	4105	98.62	24024	318.76	266.76	585.52	186	314.8	53.02	2008
95	Indiana Jones and the Kingdom of the Crystal S...	Paramount	77	59	Pursuit	Action	4260	100.1	23507	317.1	469.53	786.64	185	425.21	54.11	2008
96	Hancock	Sony	40	67	Discovery	Action	3965	62.6	15789	227.95	396.44	624.39	150	416.26	41.73	2008
97	WALL-E	Disney	96	89	love	Animation	3992	63.09	15803	223.81	297.5	521.31	180	289.62	35.05	2008
98	Kung Fu Panda	Paramount	88	83	Underdog	Animation	4114	60.24	14642	215.43	416.31	631.74	200	315.87	30.12	2008
99	Madagascar: Escape 2 Africa	Paramount	64	73	Journey and Return	Animation	4056	63.11	15559	180.01	423.89	603.9	150	402.6	42.07	2008
100	Twilight	Summit	49	82	Love	Romance	3419	69.64	20368	192.77	199.85	392.62	37	1061.12	188.22	2008