Extend IF function until blank cell is found

[damobilebrood]

Hello all,
I have a formula that is working as intended, but I would like the IF function to continue to look at the next cell in the column (B). If it is not blank, I want it to grab the cell's value and place a period after it, then move on to the next cell.

So, the end of the formula shown below, I would like it to continue with:
IF('TABLE&FIELDS'!B3<>"",'TABLE&FIELDS'!B3&".")
IF('TABLE&FIELDS'!B4<>"",'TABLE&FIELDS'!B4&".")
IF('TABLE&FIELDS'!B5<>"",'TABLE&FIELDS'!B5&".")

all the way to the first blank cell in the column (which might be a few hundred cells).
Any advice on how to extend the function out, without going cell by cell?
Thanks, in advance!

If Statement.png

[WideBoyDixon]

If you're on Office 2016 then I think TEXTJOIN is your friend here so your formula would become:

Please Login or Register  to view this content.

WBD

[6StringJazzer]

If you're on Office 2016 then I think TEXTJOIN is your friend

TEXTJOIN is available in 2019 forward (not 2016).

[WideBoyDixon]

TEXTJOIN is available in 2019 forward (not 2016).

Oh nuts!! How about:

Please Login or Register  to view this content.

Enter as an array formula with Ctrl+Shift+Enter.

WBD

[menem]

Maybe

Please Login or Register  to view this content.

Follow with Ctrl-Shift-Enter for array formula.

Regards.

[damobilebrood]

Thanks for the responses! Actually, the TEXTJOIN did the trick on this one!
Much appreciated, all!