How to hide rows depending on value in a table with VBA?

[toblju]

I have a table ("Table1") with three columns; Country-Member-Amount.
I would like to hide all rows with no value in the "Member" column (with a button).
But I would not like to hide the entire row (as I have info to the right need to be visible).
Please help!

 

[Kemmuniemans]

To my knowledge you can only hide entire rows or entire columns.

I don't even know how you could hide just the country-member-amount columns on that row and leave data after that visible, people would see hidden rows there, so what's the point?

 

[toblju]

Anyone who knows if it is possible to do above with hiding the whole row?