Need to calculate the total and combine the two tables

[Lakshmikanth_2021]

Need to calculate the total of three tables and also consolidated table. 

Once calculated total, need to convert in to PDF by add white spaces between columns.

Attached is the input and expected output files. 

[martinding]

 

Hi @Lakshmikanth_2021 ,

I have done an example for the Boys, the formatting is not exactly the same as the example you provided, but it is fairly close.

For the Girls, you would just repeat the same steps. To get the consolidated scores, you can simply just grab the last row from each table for boy/girl respectively and add them together (you can use a multirows formula tool for example).

Please see my attached workflow for more details.

Hopefully this is helpful to you, and please like if it is.