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
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.