For e.g., in this row, how can I make “Did I play soccer?” cell as row header and then apply a filter “>=0” to show only the cells/columns containing time values?
If this data would have been transposed, then I can easily apply a filter “>=0” to show only the cells/rows containing time values with this method: Selecting the column> data> autofilter, then click on the toggle beside “Did I play soccer?” column header> filter by condition> standard filer.
