How to align rows for subtraction? Need identifiers.

[wonka1234]

Hi,

I have values that need to be subtracted but the row names do not match.

How can I align these to do a subtraction?

side A:

side B:

this is just sample data. But the rows "Name" arent the same but the #'s are supposed to be aligned so it can be suctracted to 0.

How can I create identical identifiers to match the records?

Thanks.

[IraWatt]

@wonka1234 with your example above what final output would you want?

[wonka1234]

@IraWatt   final output: 

Name	Value	Name	Value
CMB Coupon Payment (incl.expenses)	-80347992.77	PYMT (Seller Swap)_Transfer User	-80347992.77
Swap interest receipt via CPA (incl.expenses)	20210839.98	FloatingInt_TransferUser	20210839.98

Then from here I can do a subtraction

[wonka1234]

i would need to do this at a large scale. It seems like i need a way to manually order rows.

[IraWatt]

@wonka1234 here's one way which should be quite dynamic at large scale:

One thing to note is you cant have columns with the same name in Alteryx.