excel problem formula to copy a vertical list but without blanks

windows 20H2 Excel 2108

I have list with some blanks in B2-B12. i want to recreate the list without the blanks in D2-D12.

I got this formula from the internet:

=IF(ROW()-ROW($B$2:$B$12)+1>ROWS($B$2:$B$12)-COUNTBLANK($B$2:$B$12),"", INDIRECT(ADDRESS(SMALL((IF($B$2:$B$12<>"",ROW($B$2:$B$12),ROW()+ROWS($B$2:$B$12))), ROW()-ROW($D$2:$D$12)+1),COLUMN($B$2:$B$12),4)))

i put formula in D2-D12. seems to work in D2 (there is text in B2 so it brings the text over).

seems to reorder the list such that the 7 non-blank cells are at the top and the blank ones at the bottom ... which is what I want. BUT in cells D3-D8 I get a "#NUM!" error instead of the texts from non-blank cells B4,B5,B7,B9,B10,B11.