How to get a specific number of cells using an array formula in Google Sheets

user_12876028 0
Viewed 29

I want to pre-process my data like the Result section of the attached image before flattening and using it.

I want to write an array formula in the cells marked in blue. How do I get results?

enter image description here

google-sheets-formula google-sheets if-statement arrays split
1 Answers

try:

=ARRAYFORMULA(IF(COLUMN(A2:D5)<=F2:F5; A2:D5; ))

enter image description here

user_56326290
Related