Apply Difference formula's column rules to compare with dynamically added columns

[Niks_diageo]

Hey Guys..,

I have dataset where every month new column added. I want solution on creating

i) difference of column2 - column1 created dynamically for all columns and (as nominator)

ii) need column1 as selected dynamically (as denominator)

please refer attached dataset for the reference..

Thank you in advance.

Regards,

Nikhil Panchal

[Qiu]

@Niks_diageo 
I tried something as below.
Transpose is a great tool for dynamic requirement. 😁
I have also highlighted the points we need to take care of.