I have data to import from google sheet that are random and I need to get it in reversed row order using importrange function in another sheet? The formula needs to be flexible as the row number in imported range may vary.
Can you help me to find solution? I was looking for Query parameters but I found only desc/asc parameter which is not helpful in this case. I can't make any "helping" column in this sheet.
Sample sheets: importrange source sheet -
update:
=ARRAY_CONSTRAIN(QUERY(SORT({
IMPORTRANGE("1FbovD-T1ickPSat-RFsz_lk-HWZw6Ge-B87A4vhwLZc"; "Plan dnia!A2:M700")\ SEQUENCE(ROWS(
IMPORTRANGE("1FbovD-T1ickPSat-RFsz_lk-HWZw6Ge-B87A4vhwLZc"; "Plan dnia!A2:M700")))\TRIM(FLATTEN(QUERY(TRANSPOSE(
IMPORTRANGE("1FbovD-T1ickPSat-RFsz_lk-HWZw6Ge-B87A4vhwLZc"; "Plan dnia!A2:M700"));;9^9)))}; 14; 0);
"where Col15 is not null"; 0); 9^9; 13)