Subtracting Row 1 minus Row 2 for Discrepancy

[Srikanth_Dahima]

I have my Input data as below 

Description	8901687006	Total
Ending Balance as Per Cash Sheet	16886.9	16886.9
Ending Balance As per Bank	16886.9	16886.9

Expected Output is

Description	8901687006	Total
Ending Balance as Per Cash Sheet	16886.9	16886.9
Ending Balance As per Bank	16886.9	16886.9
Discrepancy	0	0

Thanks in advance for your help

[alexnajm]

I have a suspicion that there is more data beyond this, but for the data you have presented I would use a Crosstab tool to move the Description to headers, calculate the Discrepancy with a Formula, and Transpose back

[alexnajm]

You can do something similar for the total if it's needed

[Srikanth_Dahima]

Hey @alexnajm Thanks for Looking into So If i need to do it for Total Coloum also then i have to use this tools Multiple times with the data we have and then Union it

[alexnajm · Accepted solution]

You have a workflow that works for one - now you can use similar (if not the same) logic for the Total column and any other columns you may have 😊 I don't want to assume what your data looks like so I can't help further

[Srikanth_Dahima]

Thank you So much for your help on this.

[MelGibson · Accepted solution]

I am sure there is an easier way, but this was the quickest way for me. Hope it helps. 

[Srikanth_Dahima]

Thank you This looks easier and Cleaner 

[alexnajm]

Agreed!