'arrayformula results go into next column after hitting array constraint and so on, in google sheets
So what I need is after reaching the limit on array_costraint, I want to continue the result into the next column, is that possible?
Here is what I have at the moment
=ARRAY_CONSTRAIN(ARRAYFORMULA(FILTER('Application Details.'!$B19:$B80,'Application Details.'!$E19:$E80="America")),25,1)
or if its possible to do the arrayformula results horizontally then continue to the next row and so on.
Here is my sample sheet https://docs.google.com/spreadsheets/d/16XaAm42slGIHuf6K9_Z3N_ddlbsLZLp7mUl8EN_Igbo/edit?usp=sharing
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
