Ignore Blanks When Using Char(10)

MichaelO1

Hello, I am having display issues when using Join Collect and Char(10).

=JOIN(COLLECT([Helper Site 1]@row + CHAR(10) + [Helper Site 2]@row + CHAR(10) + [Helper Site 3]@row + CHAR(10) + [Helper Site 4]@row + CHAR(10), [Helper Site 1]@row + CHAR(10) + [Helper Site 2]@row + CHAR(10) + [Helper Site 3]@row + CHAR(10) + [Helper Site 4]@row + CHAR(10), @cell <> ""))

Results:

How do I get the blank to not display and have the 444 Site 4 to move up?

Samuel Mueller

@MichaelO1 It would not stop, because they are separate, they are not nested, in this case.

Samuel Mueller

Unfortunately you are going to have to separate out your formula.

if([helper site 1]@row = "", "", [helper site 1]@row + char(10)) + if([helper site 2]@row = "", "", [helper site 2]@row + char(10))

something like that

MichaelO1

Hello, wouldn't that formula stop if helper site 1 is blank and not look at helper site 2, 3, 4, etc?

Samuel Mueller

@MichaelO1 It would not stop, because they are separate, they are not nested, in this case.

MichaelO1

Thank you Samuel it worked!!