Table Sorting for both Row Data and Column Data
For excel Tables give an option to filter both columns and rows using drop downs. This would eliminate the need for transposing. Right now, filters are only at the top row and filter column data. I would like to use this feature and then filter the row data. So there would be a drop down arrow across the top row and also filters for each row going from top to bottom in the first column of a Table.
Love this idea; however, would love for this feature to not be exclusive to creating an actual "Table" in excel. Would be much nice if you could just add an autofilter to any set of data, regardless if you have it formatted in an actual table.
Much like Filtering works on data that has a column header and data running vertically, there have been many occasions I've needed to Filter on data where my header is, for example, located in cell A2 and my data is displayed from A3 to Z3. Horizontal filtering would be super useful!