Hello everyone,
I am trying to populate values based on the response 'No' from a survey results table. I am trying to get a report that gives me the name of the person first followed by question ID and the comment if he said No. Below is a table representation of what I am trying to achieve. I have tried all sorts of things and was just wondering if I am trying something that is not possible on Excel. Could anyone confirm the possibility of this please.
I have a table that looks like this
and I am trying to get a report that looks something like this
I am trying to populate values based on the response 'No' from a survey results table. I am trying to get a report that gives me the name of the person first followed by question ID and the comment if he said No. Below is a table representation of what I am trying to achieve. I have tried all sorts of things and was just wondering if I am trying something that is not possible on Excel. Could anyone confirm the possibility of this please.
I have a table that looks like this
ID | Jack | Jack1 | Jack2 | Don | Don1 | Don2 | Abe | Abe1 | Abe2 |
1 | Yes | NA | Yes | NA | No | Test comment | |||
2 | Yes | NA | No | Test comment | No | Test comment | |||
3 | Yes | NA | Yes | NA | Yes | NA | |||
4 | Yes | NA | No | Test comment | Yes | NA | |||
5 | Yes | NA | Yes | NA | No | Test comment |
and I am trying to get a report that looks something like this
Jack | ||
Don | 2 | Don2 |
4 | Don2 | |
Abe | 1 | Abe2 |
2 | Abe2 | |
5 | Abe2 |