Toggle to contract columns and rows show only cells that are non-empty

dp@ii.net

There are so many elegant ways to filter rows and hide/show columns that there must be a way to do these 2 things.

Want 2 things that are related, but implemented in different ways.

1) a toggle on top of a set of of columns that when clicked, hides/shows rows that have cells that are empty for that column i.e. collapse the table/search for non empty rows in this clicked column.

2) a toggle (on/next to) each row that when clicked hides/shows columns that have cells that are empty for that column i.e. if a column is empty for that row, hide it.

any ideas?

dp@ii.net

Here is an example of how sparse filtering could be implemented. Looks a bit weird when you click on column headers and rows but it works.

http://live.datatables.net/fuciciva/3/edit