Case 2 – Keep the most recent series and add history

Another option when it comes to combining series is the formula JoinMoreHistory(series1, series2). 

This function will complement series1 with the values of series2 that are before the start of series1. You would typically use this function when you need to add history to a series. 

Here’s how it will look: 

To the see exact construction of the document, you can download the file here.