compute difference of excel spreasheets with same values and populate one below the other

[SrinivasanSugumaran]

Hi Team,

Can you pls. help me to get the desired output.
I have two excel spreadsheets ( ideally both are same templates but for Different month i.e the structure of the templates are same it is just the values which are different), and I need to compute
I) the difference between all the cols. in the templates and

II) populate one below the other.

 Month 1 ( the number of rows/cols given are limited to 5 though the actual nbr. of rows/cols is 45/17)

Description	A	B	C	D	E
M	10	20	30	40	50
N	100	200	300	400	500

Month 2

Description	A	B	C	D	E
M	60	80	90	105	110
N	600	700	800	900	1000

Output:
Should have input 1 input 2, and output one below the other in the same excel worksheet.

Description	A	B	C	D	E
M	10	20	30	40	50
N	100	200	300	400	500

Description	A	B	C	D	E
M	60	80	90	105	110
N	600	700	810	900	1000

Description	A	B	C	D	E
M	50	60	60	65	70
N	500	500	510	500	500

[MattBSlalom]

To get all your columns doing the same calculation, first I'd Transpose them so each field becomes a row, then Join the 2 transposed months together, and perform the subtraction with a Formula tool.  After that, add a Crosstab to get the results back into the multiple-field format.  To get multiple tables into a single Excel sheet, we need to use the Reporting palette tools to turn each dataset into a Table, union those table reporting objects together, then Render them into an Excel file.