Greetings:
I have an excel spreadsheet that has a list of attributes in column A. Columns B through F either have an x or are blank. Using the criteria in column A, I'd like to know if there is a way to filter so that only the columns with an "x" show.
In other words, I'm trying to figure out if there's a way to Filter data Columns wise i.e. Horizontally, the way that Auto Filter allows you to do for Rows i.e. Vertical data
thank you!
I have an excel spreadsheet that has a list of attributes in column A. Columns B through F either have an x or are blank. Using the criteria in column A, I'd like to know if there is a way to filter so that only the columns with an "x" show.
In other words, I'm trying to figure out if there's a way to Filter data Columns wise i.e. Horizontally, the way that Auto Filter allows you to do for Rows i.e. Vertical data
thank you!
Attachments
Last edited: