I have some data in sheet1,and sometimes the data starts in columns A4:C4, sometimes A8:C8, or sometimes another row. I’d like to get these data (only the first five rows of data) from sheet1 to columns A1:C5 in sheet2. So that every time the data is updated, only the first five rows of data will be retrieved from sheet1.
Can I a little help please, thanks in advance.
>Solution :
I’d think this would work:
=ARRAY_CONSTRAIN(FILTER(Sheet1!A:C,Sheet1!A:A<>""),5,3)
