jpelletierfl
New Member
- Joined
- Oct 18, 2022
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
Hello,
I am looking to see if there is a way, wether it be through FBA or functions to find only the cells that have values in a table and return the row and column header in a list form ignoring all blanks.
Below is an example of the table and list I am looking to have it return
Each person can have a value in multiple columns but I do not want to return blank cells.
Is this possible?
I am looking to see if there is a way, wether it be through FBA or functions to find only the cells that have values in a table and return the row and column header in a list form ignoring all blanks.
Below is an example of the table and list I am looking to have it return
Each person can have a value in multiple columns but I do not want to return blank cells.
Is this possible?