Hi,

So i've been to trying figure out a formula or most likely a Macro that would solve my issue here.

I have a column that has formulas in every cells (say D2:D30) and depending on the choices you make on that sheet, this column will display the information.
It works great but I would LOVE to know if there's actually a way to hide the cells that return nothing, so that it would be aesthetically more pleasing.

To be clear, right now the end result looks a bit like this:
result1

result2
result3




result4
result5
result6



result7
...



.. and of course I want it to look like this:

result1
result2
result3
result4
result5
result6
result7
...

even though, between "result1" and "result2" there is a cell with a formula. Sorta like a hide cell if empty macro (or if cell="").... i don't know.
I'm at a loss here, any help would be REALLY appreciated.

Thanks a million