Hi,
I need to extract the table header values & corresponding column values based on where the conditions meet.
in this particular example, wherever a cell value is "N", the output should return the corresponding header Value and the name of the student.
I've attached the workbook, you help is really appreciated. Thanks
2020-11-08_15-06-50.png
Bookmarks