Ignoring Blank Rows in a List

Options

Hello,

Trying to figure out how to display results in a cell that will ignore blank rows. I have a cell that lists results in the following manner:

Site 1

Site 2


Site 4

Site 5


Site 7

Is there a way to list the results without the blank rows between site 2 and 4 and between site 5 and 7?

cell formula: =[Helper Site 1 ID]@row + " " + [Helper Site 1 Name]@row + CHAR(10) + [Helper Site 2 ID]@row + " " + [Helper Site 2 Name]@row + CHAR(10) + [Helper Site 3 ID]@row + " " + [Helper Site 3 Name]@row + CHAR(10) + [Helper Site 4 ID]@row + " " + [Helper Site 4 Name]@row + CHAR(10) + [Helper Site 5 ID]@row + " " + [Helper Site 5 Name]@row + CHAR(10) + [Helper Site 6 ID]@row + " " + [Helper Site 6 Name]@row + CHAR(10) + [Helper Site 7 ID]@row + " " + [Helper Site 7 Name]@row + CHAR(10) + [Helper Site 8 ID]@row + " " + [Helper Site 8 Name]@row + CHAR(10) + [Helper Site 9 ID]@row + " " + [Helper Site 9 Name]@row + CHAR(10) + [Helper Site 10 ID]@row + " " + [Helper Site 10 Name]@row + CHAR(10)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!