Using the same workbook, copy both datasets into one worksheet so that they can be used together in a pivot table. Transpose them using Paste Special Transpose.

Data from Alphabet Financials.xlsx

Alphabet Inc. Class C
Income Statement (Industrial)
All figures in millions of U.S. Dollar.
	6/30/2019	3/31/2019	12/31/2018	9/30/2018	6/30/2018	3/31/2018	12/31/2017	9/30/2017	6/30/2017	3/31/2017	12/31/2016	9/30/2016	6/30/2016	3/31/2016	12/31/2015	9/30/2015	6/30/2015	3/31/2015	12/31/2014	9/30/2014	6/30/2014	3/31/2014	12/31/2013	9/30/2013
Sales	38,836	36,202	39,151	33,656	32,758	31,393	32,521	27,963	26,007	24,533	25,877	22,346	21,422	20,088	20,998	18,389	17,256	16,947	17,956	16,513	15,949	15,412	16,855	14,871
Cost of Goods Sold (COGS) incl. D&A	17,296	16,012	17,918	14,281	13,883	13,467	14,267	11,148	10,373	9,795	10,661	8,699	8,130	7,648	8,188	7,037	6,583	6,356	6,921	6,317	6,114	5,961	7,443	6,413
Gross Income	21,540	20,190	21,233	19,375	18,875	17,926	18,254	16,815	15,634	14,738	15,216	13,647	13,292	12,440	12,810	11,352	10,673	10,591	11,035	10,196	9,835	9,451	9,412	8,458
SG&A Expense	12,468	12,022	13,155	11,149	10,896	10,678	10,392	8,842	8,769	8,387	8,764	7,985	7,402	7,267	7,761	6,930	6,319	6,455	6,783	6,104	5,583	5,344	5,522	5,025
EBIT (Operating Income)	9,072	8,168	8,078	8,226	7,979	7,248	7,862	7,973	6,865	6,351	6,452	5,662	5,890	5,173	5,049	4,422	4,354	4,136	4,252	4,092	4,252	4,107	3,890	3,433
Nonoperating Interest Income	653	522	542	481	456	399	400	306	294	312	325	318	307	270	274	259	240	226	222	187	169	168	215	201
Equity in Earnings of Affiliates	(16)	(40)	19	(27)	(105)	(7)	(63)	(31)	(13)	(49)	7	(61)	(43)	(105)	-	-	-	-	-	-	-	-	-	-
Other Income (Expense)	(341)	363	1,710	277	226	378	(198)	(234)	(15)	401	(37)	321	128	129	(30)	297	452	378	(64)	33	79	182	(81)	(77)
Interest Expense	25	35	29	28	27	30	36	27	21	25	33	29	32	30	26	26	26	26	25	25	27	24	21	22
Unusual Expense - Net	(2,804)	832	248	(1,154)	4,314	(2,555)	(53)	8	2,733	171	(143)	166	131	308	67	61	64	110	(142)	430	70	(39)	(44)	67
Pretax Income	12,147	8,146	10,072	10,083	4,215	10,543	8,018	7,979	4,377	6,819	6,857	6,045	6,119	5,129	5,200	4,891	4,956	4,604	4,527	3,857	4,403	4,472	4,047	3,468
Income Taxes	2,200	1,489	1,124	891	1,020	1,142	11,038	1,247	853	1,393	1,524	984	1,242	922	277	912	1,025	1,018	737	859	913	822	666	513
Other After Tax Adjustments	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	(522)	-	-	-	-	-	-	-
Net Income	9,947	6,657	8,948	9,192	3,195	9,401	(3,020)	6,732	3,524	5,426	5,333	5,061	4,877	4,207	4,923	3,979	3,409	3,586	3,790	2,998	3,490	3,650	3,381	2,955
Discontinued Operations	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	227	(185)	(68)	(198)	-	-
Net Income available to Common