RSS Amplifier

Recent Questions - Web Applications Stack Exchange · Sep 30, 2020

Remove blanks in import range of multiple arrays

0
Sign in to vote or save

This page did not load. You can still read it on the original site — the toolbar below keeps your place in the directory.

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…

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")}

Read on webapps.stackexchange.com

Comments

Nothing yet. Say the first thing.

    Sign in to join the conversation.