The only limitation with the ARRAY_CONSTRAIN function is it fetches from the upper-leftmost corner of the range. Here we combine the QUERY and TRANSPOSE functions to flip a range, so the ARRAY_CONSTRAIN formula can fetch from the lower-rightmost corner of a range.
Tag: TRANSPOSE
Easily Merge Multiple Columns Into 1 with Query & ArrayFormula
Merge multi-columned data to one column before expanding it out into a different columned layout using the QUERY and ARRAYFORMULA functions in Google Sheets.