The auto filter currently provides a button on each cell of the first line of the filtered array. Next the lines are filtered. I would appreciated the transposed form : a button on each cell of the first column of the filtered array. Next the columns would be filtered (all lines would be displayed.
To clarify, the bug reporter is requesting the feature to add auto filter to the data in the form below: (labels are on column A, not on row 1) A B C D E F 1 ID 01 02 03 04 05 2 NAME Andy Bob Candy Emily Fansy 3 Age 23 23 40 43 40 4 City BJ SH NJ BJ BJ
When bug 107348 is fixed, transposing of filtered rows could be a workaround in some cases.