Using Ironpython to remove a series of columns from a Table based on Value

Hi All,

I have a table that has columns for every hour of the day (00:00-01:00, 01:00-02:00 etc etc)
I also have a list of names and based on what they did on that hour I have a value set

01:00-02:00 02:00-03:00
Stuart Did Something

Basically I want some script that goes through the entire table of marked data and when it finds an empty value it removes the entire column.
I've tried a number of different ways but I cant get it to pick out the specific columns.

Any help with this would be greatly appreciated.

Kind Regards,

(1) Answer