(I can accept a solution to this question in either Access or Excel)
I have the attached data from a download off of a survey company.
The data is difficult to read.
I am trying to make sense of it.
There is a total of 5 questions.
Each department has answered their assigned questions as either True or False.
I need to show in easy to read format the answers and comments for each Department.
If there is a Null then that means that the dept was not assigned that question.
for example, the dept Project Finance was assigned Question 1 and Question 3 as those questions are the only ones out of 5 questions that this dept was assigned as there is a True or False for only those questions.
I think that if you see the attached excel it will make more sense (hopefully) as describing it is a little difficult.
Please let me know how to present this data in a more easily read format.
I tried a pivot but that doesnt seem to work.
fyi: I have truncated the data to only 5 questions. The original data has hundreds of questions.