I'm making a DTR system report with 4 time columns. In and out for morning and afternoon sessions, respectively. The first image is my output applying formula with conditions.
The output without the conditions applied. I was successful in hiding those values I didn't want to show up, but not on suppressing or removing those blank lines.
One of the formula's I made. Works the same with 'else "" ' added.without the single quote.
What I want to do is to remove those blank lines for every column, so that result will line up horizontally(first image). I've done a lot of suppress trials but it's gives the same result. Please need some ideas. Thank you.