Retrieve values from the top non-blank cells in a row

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.

here is a sample sheet1 file.
enter image description here

>Solution :

I’d think this would work:

=ARRAY_CONSTRAIN(FILTER(Sheet1!A:C,Sheet1!A:A<>""),5,3)

Leave a Reply