I have my Input data as below Description8901687006TotalEnding Balance as Per Cash Sheet16886.916886.9Ending Balance As per Bank16886.916886.9 Expected Output is Description8901687006TotalEnding Balance as Per Cash Sheet16886.916886.9Ending Balance As per Bank16886.916886.9Discrepancy00 Thanks in advance for your help

Subtracting Row 1 minus Row 2 for Discrepancy

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

Transformation

Accepted answers

alexnajm

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

MelGibson

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

Subtracting Row 1 from Row 2.yxmd

All comments

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

Subtracting Row 1 minus Row 2 for Discrepancy.yxmd

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

Srikanth_Dahima

Thank you So much for your help on this.

MelGibson

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

Subtracting Row 1 from Row 2.yxmd

Srikanth_Dahima

Thank you This looks easier and Cleaner

alexnajm

Agreed!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335