I Need Help with Counting Consecutive Cells

See attached.

Formula in Column B records count of blanks between values.

Put in B2

=IF($A1<>"",IF(COUNTA($A2:$A1000),MATCH(TRUE,$A2:$A1000<>"",0)-1,""),0)

Enter with Ctrl+Shift+Enter

Copy down as required

Formula in D1 extracts counts > 1 and puts them in the row,

in D1

=IFERROR(INDEX($B$1:$B$16,SMALL(IF($B$1:$B$16>1,ROW($B$1:$B$16)-ROW($B$1)+1,""),COLUMNS($A$1:A1))),"")

Enter with Ctrl+Shift+Enter


Drag formula across row as required