Hello all,
I have a bunch of 360° survey data from Google Forms in the following format:
<tbody>
</tbody>
I ultimately want to be able to be able to group the questions into categories (problem solving, planning, etc.) and produce a bar chart that I can use to filter by subject name, relationship to subject, or category/question. I was hoping I could do this in a pivot table, but I'm not sure how.
Is there a way to organize the data so that it is in a format similar to this?:
<tbody>
</tbody>
I appreciate any help anyone can offer on this.
Thanks,
Sam
I have a bunch of 360° survey data from Google Forms in the following format:
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Timestamp | Name of the survey subject | Your relationship to the survey subject | Works quickly when faced with difficult problems | Analyzes issues and reduces them to their component parts | Makes judgements based upon relevant information | Plans meetings effectively | Organizes and schedules events, activities, and resources | Sets up and monitors time frames and plans |
2 | 6/16/16 14:09 | Jon | Peer | 2 | 4 | 3 | 3 | 1 | 2 |
3 | 6/16/16 14:09 | Jon | Supervisor | 1 | 3 | 4 | 2 | 2 | 2 |
4 | 6/16/16 14:10 | Jon | Peer | 1 | 2 | 2 | 4 | 3 | 3 |
5 | 6/16/16 14:10 | Jake | Subordinate | 1 | 2 | 5 | 1 | 2 | 2 |
6 | 6/16/16 14:11 | Jake | Peer | 1 | 1 | 1 | 1 | 3 | 2 |
7 | 6/16/16 17:12 | Jon | Subordinate | 2 | 2 | 2 | 3 | 3 | 3 |
<tbody>
</tbody>
I ultimately want to be able to be able to group the questions into categories (problem solving, planning, etc.) and produce a bar chart that I can use to filter by subject name, relationship to subject, or category/question. I was hoping I could do this in a pivot table, but I'm not sure how.
Is there a way to organize the data so that it is in a format similar to this?:
D | E | F | G | H | I | |
---|---|---|---|---|---|---|
14 | Timestamp | Name of the survey subject | Your relationship to the survey subject | Question | Category | Value |
15 | 6/16/16 14:09 | Jon | Peer | Works quickly when faced with difficult problems | Problem Solving | 2 |
16 | Analyzes issues and reduces them to their component parts | Problem Solving | 4 | |||
17 | Makes judgements based upon relevant information | Problem Solving | 3 | |||
18 | Plans meetings effectively | Planning | 3 | |||
19 | Organizes and schedules events, activities, and resources | Planning | 1 | |||
20 | Sets up and monitors time frames and plans | Planning | 2 | |||
21 | 6/16/16 14:09 | Jon | Supervisor | Works quickly when faced with difficult problems | Problem Solving | 1 |
22 | Analyzes issues and reduces them to their component parts | Problem Solving | 3 | |||
23 | Makes judgements based upon relevant information | Problem Solving | 4 | |||
24 | Plans meetings effectively | Planning | 2 | |||
25 | Organizes and schedules events, activities, and resources | Planning | 2 | |||
26 | Sets up and monitors time frames and plans | Planning | 2 | |||
27 | 6/16/16 14:10 | Jon | Peer | Works quickly when faced with difficult problems | Problem Solving | 1 |
28 | Analyzes issues and reduces them to their component parts | Problem Solving | 2 | |||
29 | Makes judgements based upon relevant information | Problem Solving | 2 | |||
30 | Plans meetings effectively | Planning | 4 | |||
31 | Organizes and schedules events, activities, and resources | Planning | 3 | |||
32 | Sets up and monitors time frames and plans | Planning | 3 |
<tbody>
</tbody>
I appreciate any help anyone can offer on this.
Thanks,
Sam