Do the following question. I can pay for additional question after you did that one.

Could you Arrange the trial balances given in Raw Data and displaying them side by side on the same page. When doing this, please pull the data from the raw trial balances with excel formulas.

2014 Trial Balance
Account Code	Debit	Credit	Debit Balance	Credit Balance
100	117,112.98	101,986.19	15,126.79	0.00
101	7,331,264.95	6,010,308.20	1,320,956.75	0.00
102	191,398,862.79	187,949,954.40	3,448,908.39	0.00
108	711,593.21	592,045.68	119,547.53	0.00
120	58,362,795.81	45,011,885.88	13,499,857.37	148,947.43
121	698,589.41	698,589.41	0.00	0.00
136	312,179.47	294,997.74	17,181.73	0.00
153	30,444,571.27	30,008,832.30	440,738.97	0.00
180	200,450.03	144,322.94	56,127.10	0.00
181	10,492.21	5,017.85	5,474.36	0.00
191	5,126,042.51	5,126,042.51	0.00	0.00
192	13,013.97	12,345.72	668.25	0.00
193	362,827.33	82,839.90	279,987.43	0.00
195	1,500.00	0.00	1,500.00	0.00
196	26,725.00	7,500.00	19,225.00	0.00
226	1,660.19	0.00	1,660.19	0.00
254	45,033.22	0.00	45,033.22	0.00
255	974,229.29	0.00	974,229.29	0.00
257	0.00	665,241.20	0.00	665,241.20
264	11,942.02	0.00	11,942.02	0.00
268	0.00	10,210.12	0.00	10,210.12
280	72,279.57	0.00	72,279.57	0.00
296	84,000.00	0.00	84,000.00	0.00
300	5,882,248.85	6,058,208.85	0.00	175,960.00
309	19,394.72	20,623.39	0.00	1,228.68
320	30,390,584.78	41,000,344.59	20,453.57	10,630,213.39
321	0.00	756,628.00	0.00	756,628.00
331	881,973.79	881,973.79	0.00	0.00
335	811,951.34	876,436.80	0.00	64,485.47
360	4,987,108.14	7,081,183.93	0.00	2,094,075.79
361	404,989.43	436,076.62	0.00	31,087.19
368	6,570.91	45,996.13	0.00	39,425.22
370	258,047.97	258,047.97	0.00	0.00
371	258,047.97	258,047.97	0.00	0.00
373	1,272,812.72	2,153,838.80	0.00	881,026.08
380	44,980.00	44,980.00	0.00	0.00
391	9,794,630.80	9,794,630.80	0.00	0.00
392	12,345.72	13,013.97	0.00	668.25
438	0.00	72,279.57	0.00	72,279.57
500	0.00	1,272,501.50	0.00	1,272,501.50
540	0.00	233,243.21	0.00	233,243.21
549	0.00	595,991.25	0.00	595,991.25
570	949,671.89	2,325,367.14	0.00	1,375,695.26
590	1,027,289.08	1,027,289.08	0.00	0.00
600	0.00	32,596,060.98	0.00	32,596,060.98
600.01	0.00	31,948,206.31	0.00	31,948,206.31
600.02	0.00	647,854.67	0.00	647,854.67
601	0.00	108,475.24	0.00	108,475.24
601.01	0.00	104,548.04	0.00	104,548.04
601.02	0.00	3,927.20	0.00	3,927.20
602	0.00	125,203.67	0.00	125,203.67
610	86,605.79	9,114.47	77,491.32	0.00
621	29,098,113.98	188,167.32	28,909,946.67	0.00
642	0.00	37,231.30	0.00	37,231.30
646	311.79	1,169,186.76	0.00	1,168,874.97
653	43,615.00	65.65	43,549.35	0.00
656	1,359,128.76	0.11	1,359,128.65	0.00
679	0.00	68,629.21	0.00	68,629.21
689	13,947.20	0.01	13,947.19	0.00
760	570,962.09	0.00	570,962.09	0.00
760.01	488,530.62	0.00	488,530.62	0.00
760.02	82,431.48	0.00	82,431.48	0.00
770	1,760,622.20	50,322.38	1,710,299.82	0.00
770.01	874,800.28	0.00	874,800.28	0.00
770.03	11,264.26	0.00	11,264.26	0.00
770.04	247,297.89	8,676.18	238,621.71	0.00
770.05	135,124.59	279.76	134,844.84	0.00
770.06	122,237.11	0.00	122,237.11	0.00
770.07	155,982.10	0.00	155,982.10	0.00
770.08	20,374.03	0.00	20,374.03	0.00
770.09	7,401.32	2,296.76	5,104.57	0.00
770.10	186,140.64	39,069.69	147,070.95	0.00
780	33,316.70	156.37	33,160.34	0.00
780.01	33,316.70	156.37	33,160.34	0.00

2015 Trial Balance
Account Code	Debit	Credit	Debit Balance	Credit Balance
100	83,999.30	55,699.05	28,300.25	0.00
101	10,201,917.26	8,850,069.06	1,351,848.20	0.00
102	378,698,599.71	376,294,482.86	2,404,116.85	0.00
108	980,347.15	834,907.14	145,440.01	0.00
120	69,346,240.36	47,688,955.06	22,526,254.32	868,969.02
121	479,203.62	479,203.62	0.00	0.00
136	555,550.52	538,211.51	17,339.01	0.00
153	43,853,518.43	41,587,413.41	2,266,105.03	0.00
180	293,742.44	219,358.04	74,384.40	0.00
181	11,019.73	5,474.36	5,545.37	0.00
191	6,789,705.10	6,789,705.10	0.00	0.00
192	20,344.37	15,746.79	4,597.58	0.00
193	712,706.09	268,236.89	444,469.21	0.00
195	1,500.00	0.00	1,500.00	0.00
196	19,225.00	19,225.00	0.00	0.00
226	1,660.19	0.00	1,660.19	0.00
254	45,033.22	13,512.55	31,520.67	0.00
255	1,014,536.62	0.00	1,014,536.62	0.00
257	13,512.55	771,250.36	0.00	757,737.81
264	11,942.02	0.00	11,942.02	0.00
268	518.43	12,013.18	0.00	11,494.75
280	72,279.57	72,279.57	0.00	0.00
296	84,000.00	0.00	84,000.00	0.00
300	7,537,070.78	7,587,070.78	0.00	50,000.00
309	48,280.67	49,072.04	0.00	791.37
320	37,915,269.68	56,860,924.50	933,454.75	19,879,109.56
321	791,939.52	858,428.44	0.00	66,488.92
331	797,945.49	797,945.49	0.00	0.00
335	837,966.53	890,746.24	1,279.49	54,059.21
360	6,007,270.81	9,075,395.05	0.00	3,068,124.24
361	389,940.51	424,855.06	0.00	34,914.55
368	39,425.53	111,705.10	0.00	72,279.57
370	279,987.43	279,987.43	0.00	0.00
371	279,987.43	279,987.43	0.00	0.00
373	3,260,576.46	3,778,418.19	0.00	517,841.73
391	12,994,342.45	12,994,342.45	0.00	0.00
392	15,746.79	20,344.37	0.00	4,597.58
438	72,279.57	72,279.57	0.00	0.00
500	0.00	1,272,501.50	0.00	1,272,501.50
540	0.00	370,573.54	0.00	370,573.54
549	0.00	595,991.25	0.00	595,991.25
570	939,227.26	2,481,697.77	0.00	1,542,470.51
590	1,106,002.51	1,106,002.51	0.00	0.00
600	0.00	43,676,029.15	0.00	43,676,029.15
600.01	0.00	42,534,329.14	0.00	42,534,329.14
600.02	0.00	1,141,700.01	0.00	1,141,700.01
601	0.00	151,816.13	0.00	151,816.13
601.01	0.00	140,027.29	0.00	140,027.29
601.02	0.00	11,788.84	0.00	11,788.84
602	0.00	109,785.55	0.00	109,785.55
610	800,680.08	0.00	800,680.08	0.00
621	39,674,683.57	1,288,791.37	38,385,892.21	0.00
642	0.00	164,844.36	0.00	164,844.36
646	0.00	1,156,815.70	0.00	1,156,815.70
653	136,417.34	497.57	135,919.78	0.00
656	1,443,845.19	32,444.81	1,411,400.39	0.00
679	32.80	84,232.33	0.00	84,199.53
689	41,997.20	0.00	41,997.20	0.00
760	555,247.26	4,715.60	550,531.66	0.00
760.01	435,280.84	0.00	435,280.84	0.00
760.02	119,966.42	4,715.60	115,250.82	0.00
770	1,833,693.15	3,999.89	1,829,693.26	0.00
770.01	905,158.52	0.00	905,158.52	0.00
770.03	26,788.92	325.84	26,463.08	0.00
770.04	280,092.48	317.48	279,775.00	0.00
770.05	151,400.56	206.15	151,194.41	0.00
770.06	128,589.53	0.00	128,589.53	0.00
770.07	128,158.95	0.00	128,158.95	0.00
770.08	18,880.33	0.00	18,880.33	0.00
770.09	14,196.88	3,150.42	11,046.46	0.00
770.10	180,426.99	0.00	180,426.99	0.00
780	8,159.32	1,132.30	7,027.02	0.00