Find value of every nonblank that's to the right of a blank, repeating along a range

[sbawnh]

	A	B	C	D	E	F	G	H	I	J	K
1		6/10/2018		6/29/2018	8/2/2018				12/31/2018
2

<tbody>
</tbody>

Hi,

Is it possible to show the value of B1, D1, and I1 laid out maybe in columns L:X.

This is every cell to the right of one or many blanks.

 

[Rick Rothstein]

I am not sure why you want to put formulas out to Column X given that the maximum number of columns that will ever be needed is 9 (assuming Column I is the last cell that will be filled) which means you can stop at Column T. With that said, put this array-entered** formula in cell L1 and copy it across to cell T1...

=IFERROR(SMALL(IF(($A1:$H1="")*($B1:$I1<>""),$B1:$I1),COLUMNS($B:B)),"")

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

 

[sbawnh]

It's an honor. Thank you for your answer!