How to Remove Blanks from List Using Formula in Excel (4...
Method 1 – Removing Blanks from a Vertical List in Excel Using an Array Formula Step 1 In cellD5, enter the following array formula: =INDEX($B$5:$B$14, SMALL(IF(ISBLANK($B$5:$B$14), “”, ROW($B$5:$B$14)-MIN(ROW($B$5:$B$14))+1), ROW(A1))) ...