I have an importrange formula as below which references multiple ranges, calling the sheet URL's using the 'L Links'!Bx, reference, each 'book' having an identical sheet set. (There are actually 90 URL's but I have only shown part here.) It works fine, except, it brings back all the blank rows, and the ranges vary in length.
Is there a simple way of removing the blank rows in the formula en masse?
={importrange('L Links'!B3,"'Donor Projection Input'!A2:H");importrange('L Links'!B4,"'Donor Projection Input'!A2:H");importrange('L Links'!B5,"'Donor Projection Input'!A2:H");importrange('L Links'!B6,"'Donor Projection Input'!A2:H");importrange('L Links'!B7,"'Donor Projection Input'!A2:H");importrange('L Links'!B8,"'Donor Projection Input'!A2:H")}