An Algorithmic Resolution
When two (or more) values must be aligned, then one option is to introduce an algorithmic solution. In the algorithmic solution, data from one spreadsheet is taken and algorithmically recalculated into the form of the other spreadsheet. However, it is not always possible to find an algorithmic solution.