How to hide the columns after using the filter?

[chanshingkwan]

Dear ALL,

I would like to ask how can I I hide the columns after using the filter?
Either one question of both can be solved is ok for me, thank guys!

First of all, by using the worksheet below,

Let's use "A8" as the filter cell.
Then I would like filter out the Row 9.
Let's see and imagine there are both cells "D9" and "H9" have values.
What shall I do if I want to hide the columns without any value automatically?
Therefore, is it possible to unhide the column D and H, and hide the other columns after I filter out Row 9.

Or by using another worksheet,

In Column H, I had filtered the value in descending.
There are some values in Column H, I, J, L, M, but not Column K.
However, I would like to hide the column K automatically since there are no values in column K unless the row in Column H has no value.
Then, the column K may has value. (In the whole spreadsheet, all columns and all rows have at least one cell has a value.)
Is it possible to unhide the Column H, I, J, L, M but hide Column K automatically?

Thank you and looking for the solutions.

PS: I'm using the google drive.