In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value by a "simple click".
For example, say a I have the weekdays repeating over and over in one column and various data in the other columns. By the filtering described above, I can, with a click, show rows corresponding to, say, mondays only.
If we call the filtering described above vertical, how do I accomplish horizontal filtering in the same simplistic manner?
It should be very simple, but I cannot find any way to do this. Annoying!