how can I merge two time series (like IND1 and IND2) to get IND3. The calculations to join both series can be seen in the attached excel file.
I want IND3 to consist of IND1 until the MERGE_DATE and thereafter of IND2 (as specified in the table mergetable).
In the original file IND3 is missing and should be calculated via VBA (or SQL if possible).
In this example the timestamps of IND1 and IND2 are identical, that is not always the case
therefore before MERGE_DATE the timestamps should be from IND1 (MNEMONIC_first) thereafter from IND2 (MNEMONIC_second)
Thanks for your help.