Formatting Not working on a view specified by an expression

[bman22]

Hello I had a question, well actually 2. The first one is in the following expression: 

CONCATENATE(

"• ";[Task 1],"
",IF([Task 2]<>"N/A",[Task 2],""),"
",IF([Task 3]<>"N/A",[Task 3],""),"
",IF([Task 4]<>"N/A",[Task 4],""),"
",IF([Task 5]<>"N/A",[Task 5],""),"
",IF([Task 6]<>"N/A",[Task 6],""),"
",IF([Task 7]<>"N/A",[Task 7],""),"
",IF([Task 8]<>"N/A",[Task 8],""),"
",IF([Task 9]<>"N/A",[Task 9],""),"
",IF([Task 10]<>"N/A",[Task 10],""))

How do I get the dot • to add onto the beginning of all the other column values as well as a text value attached onto the column value? Whenever I tried what I did for Task 1, it either showed the dot and not the column value or the other way around. Also when I look at this in the Ref view it shows blank lines if the criteria is met so how do I remove all the blank space? Such as the Organize Data into sensible chunks part? It doesn't remove the space once it has been filtered, which nothing I have done to get rid of it works unfortunately. I wanted the value to not show including the blank space if it equals "N/A".

[Joseph_Seddik · Accepted solution]

A solution that works:

"• " & [Task 1]
& IF([Task 2]= "N/A", "", "• " & [Task 2])
& IF([Task 3]= "N/A", "", "• " & [Task 3])
|
|
& IF([Task 10]= "N/A", "", "• " & [Task 10])

Good Solution:

Do not use columns as a list, but instead have a Tasks table with relevant table references. In this case your expression will be a single line:

SUBSTITUTE([Related Tasks], " , ", " • ")

[bman22]

Thanks for the help, appreciate it!