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
|
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.