I have an interesting scenario. There is a column named "Description" which can show up in any column. Within the "Description" field, each cell contains several lines of text. There are instances where there are several blank lines that I would like to remove so there is only one blank line. For Example, consider the following text:
"I want to remove 1 of the 2 blank lines below
so that the text appears normally"
One of the requirements is if there is only 1 blank line, then that is okay. Only remove blank lines that aren't needed and replace it with 1 blank line. So...
IF "count of lines" > 1 then "trim so only 1 blank line is present" else "leave alone"