Hello all,
I have a bunch of 360° survey data from Google Forms in the following format:
[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]
[TH]
[TH]
[TH]
[TH]
[TH]
[TH]
[TH]
[TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]Timestamp[/TD]
[TD]Name of the survey subject[/TD]
[TD]Your relationship to the survey subject[/TD]
[TD]Works quickly when faced with difficult problems[/TD]
[TD]Analyzes issues and reduces them to their component parts[/TD]
[TD]Makes judgements based upon relevant information[/TD]
[TD]Plans meetings effectively[/TD]
[TD]Organizes and schedules events, activities, and resources[/TD]
[TD]Sets up and monitors time frames and plans[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jon[/TD]
[TD]Peer[/TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jon[/TD]
[TD]Supervisor[/TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jon[/TD]
[TD]Peer[/TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jake[/TD]
[TD]Subordinate[/TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jake[/TD]
[TD]Peer[/TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jon[/TD]
[TD]Subordinate[/TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[TD]
[/TR]
</tbody>[/TABLE]
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?:
[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]
[TH]
[TH]
[TH]
[TH]
[TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]Timestamp[/TD]
[TD]Name of the survey subject[/TD]
[TD]Your relationship to the survey subject[/TD]
[TD]Question[/TD]
[TD]Category[/TD]
[TD]Value[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jon[/TD]
[TD]Peer[/TD]
[TD]Works quickly when faced with difficult problems[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Analyzes issues and reduces them to their component parts[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Makes judgements based upon relevant information[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Plans meetings effectively[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Organizes and schedules events, activities, and resources[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sets up and monitors time frames and plans[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jon[/TD]
[TD]Supervisor[/TD]
[TD]Works quickly when faced with difficult problems[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Analyzes issues and reduces them to their component parts[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Makes judgements based upon relevant information[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Plans meetings effectively[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Organizes and schedules events, activities, and resources[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sets up and monitors time frames and plans[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD]
[TD]Jon[/TD]
[TD]Peer[/TD]
[TD]Works quickly when faced with difficult problems[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Analyzes issues and reduces them to their component parts[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Makes judgements based upon relevant information[/TD]
[TD]Problem Solving[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Plans meetings effectively[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Organizes and schedules events, activities, and resources[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sets up and monitors time frames and plans[/TD]
[TD]Planning[/TD]
[TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]
A
[/TH][TH]
B
[/TH][TH]
C
[/TH][TH]
D
[/TH][TH]
E
[/TH][TH]
F
[/TH][TH]
G
[/TH][TH]
H
[/TH][TH]
I
[/TH][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
1
[/TD][TD]Timestamp[/TD]
[TD]Name of the survey subject[/TD]
[TD]Your relationship to the survey subject[/TD]
[TD]Works quickly when faced with difficult problems[/TD]
[TD]Analyzes issues and reduces them to their component parts[/TD]
[TD]Makes judgements based upon relevant information[/TD]
[TD]Plans meetings effectively[/TD]
[TD]Organizes and schedules events, activities, and resources[/TD]
[TD]Sets up and monitors time frames and plans[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
2
[/TD][TD]
6/16/16 14:09
[/TD][TD]Jon[/TD]
[TD]Peer[/TD]
[TD]
2
[/TD][TD]
4
[/TD][TD]
3
[/TD][TD]
3
[/TD][TD]
1
[/TD][TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
3
[/TD][TD]
6/16/16 14:09
[/TD][TD]Jon[/TD]
[TD]Supervisor[/TD]
[TD]
1
[/TD][TD]
3
[/TD][TD]
4
[/TD][TD]
2
[/TD][TD]
2
[/TD][TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
4
[/TD][TD]
6/16/16 14:10
[/TD][TD]Jon[/TD]
[TD]Peer[/TD]
[TD]
1
[/TD][TD]
2
[/TD][TD]
2
[/TD][TD]
4
[/TD][TD]
3
[/TD][TD]
3
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
5
[/TD][TD]
6/16/16 14:10
[/TD][TD]Jake[/TD]
[TD]Subordinate[/TD]
[TD]
1
[/TD][TD]
2
[/TD][TD]
5
[/TD][TD]
1
[/TD][TD]
2
[/TD][TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
6
[/TD][TD]
6/16/16 14:11
[/TD][TD]Jake[/TD]
[TD]Peer[/TD]
[TD]
1
[/TD][TD]
1
[/TD][TD]
1
[/TD][TD]
1
[/TD][TD]
3
[/TD][TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
7
[/TD][TD]
6/16/16 17:12
[/TD][TD]Jon[/TD]
[TD]Subordinate[/TD]
[TD]
2
[/TD][TD]
2
[/TD][TD]
2
[/TD][TD]
3
[/TD][TD]
3
[/TD][TD]
3
[/TD][/TR]
</tbody>[/TABLE]
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?:
[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]
D
[/TH][TH]
E
[/TH][TH]
F
[/TH][TH]
G
[/TH][TH]
H
[/TH][TH]
I
[/TH][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
14
[/TD][TD]Timestamp[/TD]
[TD]Name of the survey subject[/TD]
[TD]Your relationship to the survey subject[/TD]
[TD]Question[/TD]
[TD]Category[/TD]
[TD]Value[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
15
[/TD][TD]
6/16/16 14:09
[/TD][TD]Jon[/TD]
[TD]Peer[/TD]
[TD]Works quickly when faced with difficult problems[/TD]
[TD]Problem Solving[/TD]
[TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
16
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Analyzes issues and reduces them to their component parts[/TD]
[TD]Problem Solving[/TD]
[TD]
4
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
17
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Makes judgements based upon relevant information[/TD]
[TD]Problem Solving[/TD]
[TD]
3
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
18
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Plans meetings effectively[/TD]
[TD]Planning[/TD]
[TD]
3
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
19
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Organizes and schedules events, activities, and resources[/TD]
[TD]Planning[/TD]
[TD]
1
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
20
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sets up and monitors time frames and plans[/TD]
[TD]Planning[/TD]
[TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
21
[/TD][TD]
6/16/16 14:09
[/TD][TD]Jon[/TD]
[TD]Supervisor[/TD]
[TD]Works quickly when faced with difficult problems[/TD]
[TD]Problem Solving[/TD]
[TD]
1
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
22
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Analyzes issues and reduces them to their component parts[/TD]
[TD]Problem Solving[/TD]
[TD]
3
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
23
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Makes judgements based upon relevant information[/TD]
[TD]Problem Solving[/TD]
[TD]
4
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
24
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Plans meetings effectively[/TD]
[TD]Planning[/TD]
[TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
25
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Organizes and schedules events, activities, and resources[/TD]
[TD]Planning[/TD]
[TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
26
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sets up and monitors time frames and plans[/TD]
[TD]Planning[/TD]
[TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
27
[/TD][TD]
6/16/16 14:10
[/TD][TD]Jon[/TD]
[TD]Peer[/TD]
[TD]Works quickly when faced with difficult problems[/TD]
[TD]Problem Solving[/TD]
[TD]
1
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
28
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Analyzes issues and reduces them to their component parts[/TD]
[TD]Problem Solving[/TD]
[TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
29
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Makes judgements based upon relevant information[/TD]
[TD]Problem Solving[/TD]
[TD]
2
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
30
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Plans meetings effectively[/TD]
[TD]Planning[/TD]
[TD]
4
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
31
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Organizes and schedules events, activities, and resources[/TD]
[TD]Planning[/TD]
[TD]
3
[/TD][/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
32
[/TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sets up and monitors time frames and plans[/TD]
[TD]Planning[/TD]
[TD]
3
[/TD][/TR]
</tbody>[/TABLE]
I appreciate any help anyone can offer on this.
Thanks,
Sam
