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

[sbawnh]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]6/10/2018[/TD]
[TD][/TD]
[TD]6/29/2018[/TD]
[TD]8/2/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12/31/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!