Also, if you’re not familiar with arrayformula, I wrote a post here
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts
