Currently, Google Sheets can be used to "freeze" sections of a document so that those sections always persist when scrolling, as demonstrated in this video. However, a limitation of this is that only one section can be selected, and it must be relative to the beginning of the document, whether it's defined in rows or columns.
Is it at all possible to freeze a second, separate row further down the spreadsheet so that, when scrolling, the first frozen row persists at the top of the sheet until the second frozen row is encountered and replaces the first?