Hi, I have a 'dashboard' that lists names in a column.
I have a row that INDEXES this column, horizontally, such that the column is automatically 'transposed'.
The column, however, is controlled by multiple filters in adjacent columns.
I would like the INDEXING row to ignore hidden cells after applying a filter.
Secondly, in the original column, there are some necessary blanks, depending on the filter applied. I would like these blanks also replicated horizontally.
I did find one formula online that ignored hidden rows (I've lost the link) but unfortunately it also ignore blanks.
In summary, no matter how the column is arranged/filtered, I want that column transposed verbatim.
My example file is attached.
Bookmarks