Pivoting example

	A	B	C	D	E	F	G	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV
1	Answer_for_PID	Measure_Link	Answer_VariableID	Item_Type	Answer_Output	Answer_Stat_Value	Final_Answer_Output		What I want:

2	NS10026	langhandy	Language and Handedness (Youth)	Measure_Intro	Continue	0	0	Table 1	pid	langhandcg00	langhandcg00a	langhandcg01	langhandcg02	langhandcg03	langhandcg04	langhandcg05	langhandcg06	langhandcg07	langhandcg08	langhandcg09	langhandcg09a	langhandcg10	langhandcg11	langhandcg12	langhandcg13	langhandcg14	langhandcg15
3	NS10026	langhandy	langhandy01	Option	isiXhosa	1	1		NS10026	2	0	1	2	1	1	2	2	xhosa	0	0	0	1	1	1	1	0	1
4	NS10026	langhandy	langhandy02	Option	English	0	0		NS60065	2	0	1	2	1	1	2	2	xhosa	0	0	0	1	1	1	1	0	1
5	NS10026	langhandy	langhandy03	Option	English	0	0
6	NS10026	langhandy	langhandy04	Option	isiXhosa	1	1
7	NS10026	langhandy	langhandy05	Option	Right Hand	0	0
8	NS10026	langhandy	langhandy06	Option	Right Hand	0	0		What I get:																			Example : Ben
9	NS10026	langhandy	langhandy07	Option	Right Hand	0	0	Table 2	pid	langhandcg00	langhandcg00a	langhandcg01	langhandcg02	langhandcg03	langhandcg04	langhandcg05	langhandcg06	langhandcg07	langhandcg08	langhandcg09	langhandcg09a	langhandcg10	langhandcg11	langhandcg12	langhandcg13	langhandcg14	langhandcg15	pid	langhandcg00	langhandcg00a	langhandcg01	langhandcg02	langhandcg03	langhandcg04	langhandcg05	langhandcg06	langhandcg07	langhandcg08	langhandcg09	langhandcg09a	langhandcg10	langhandcg11	langhandcg12	langhandcg13	langhandcg14	langhandcg15
10	NS10026	langhandy	langhandy08	Option	Right Hand	0	0		NS10026	4	0	2	4	2	2	4	4		0	0	0	2	2	2	2	0	2	NS10026	4	0	2	4	2	2	4	4	xhosayoyouyuoyoy	0	0	0	2	2	2	2	0	2
11	NS10026	langhandy	langhandy09	Option	Right Hand	0	0		NS60065	4	0	2	4	2	2	4	4		0	0	0	2	2	2	2	0	2	NS60065	4	0	2	4	2	2	4	4	xhosa	0	0	0	2	2	2	2	0	2
12	NS10026	nsy	NeuroScreen (Youth)	Measure_Intro	Continue	0	0
13	NS10026	nsy	nsy01	Measure_Instruction	Continue	0	0
14	NS10026	nsy	nsy02	Measure_Instruction	Continue	0	0
15	NS10026	nsy	nsy03	Option	Yes	1	1		When I combine the Query with Importrange to create the above pivot table from another sheet I get the error:
16	NS10026	coding	WISC Digit Symbol Coding	Measure_Intro	Continue	0	0		"Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC"
17	NS10026	coding	coding_strucutre	Item_Instruction	Continue	0	0
18	NS10026	coding	codinginst1	Measure_Instruction	Continue	0	0		How can I rearrange my data to look like Table 2 using QUERY and IMPORTRANGE? Or via some other method?
19	NS10026	pqai	Parent Questionnaire and Asset Index	Measure_Intro	Continue	0	0
20	NS10026	pqai	pqai05	Option	Black	1	1
21	NS10026	pqai	pqai08	Option	Female	2	2	pid	langhandcg00	langhandcg00a	langhandcg01	langhandcg02	langhandcg03	langhandcg04	langhandcg05	langhandcg06	langhandcg07	langhandcg08	langhandcg09	langhandcg09a	langhandcg10	langhandcg11	langhandcg12	langhandcg13	langhandcg14	langhandcg15
22	NS10026	pqai	pqai09	Number	44	0	0	NS10026	2	0	1	2	1	1	2	2	xhosayoyouyuoyoy	0	0	0	1	1	1	1	0	1
23	NS10026	pqai	pqai12	Option	R5001 - R25 000	2	2	NS60065	2	0	1	2	1	1	2	2	xhosa	0	0	0	1	1	1	1	0	1
24	NS10026	pqai	pqai13	Option	8-11 years	3	3
25	NS10026	pqai	pqai14	Option	7 years	2	2
26	NS10026	pqai	pqai15	Option	Not Applicable	-7	-7
27	NS10026	pqai	pqai15a	Text	The child is leaving with the biological parents not the guardian.	0	0
28	NS10026	pqai	pqai16	Option	Unskilled	7	7	pid	Language and Handedness (Caregiver)	langhandcg00	langhandcg00a	langhandcg01	langhandcg02	langhandcg03	langhandcg04	langhandcg05	langhandcg06	langhandcg07	langhandcg08	langhandcg09	langhandcg09a	langhandcg10	langhandcg11	langhandcg12	langhandcg13	langhandcg14	langhandcg15
29	NS10026	pqai	pqai17	Option	Unskilled	7	7	NS10026	0	2	0	1	2	1	1	2	2	xhosayoyouyuoyoy	0	0	0	1	1	1	1	0	1
30	NS10026	pqai	pqai18	Option	Not Applicable	-12	-12	NS60065	0	2	0	1	2	1	1	2	2	xhosa	0	0	0	1	1	1	1	0	1
31	NS10026	pqai	pqai18a	Text	Child does not live with a guardian, she lives with biological parents.	0	0
32	NS10026	pqai	pqai19	Option	Yes	1	1
33	NS10026	pqai	pqai20	Option	No	0	0	pid	Language and Handedness (Caregiver)	langhandcg00	langhandcg00a	langhandcg01	langhandcg02	langhandcg03	langhandcg04	langhandcg05	langhandcg06	langhandcg07	langhandcg08	langhandcg09	langhandcg09a	langhandcg10	langhandcg11	langhandcg12	langhandcg13	langhandcg14	langhandcg15
34	NS10026	pqai	pqai21	Option	Yes	1	1	NS10026	Measure_Intro	List	Option	Option	Option	Option	Option	Option	Option	Text	Option	Option	Text	Option	Option	Option	Option	Number	Option
35	NS10026	coding	codingpic	Photo	0		[object Object]	NS60065	Measure_Intro	List	Option	Option	Option	Option	Option	Option	Option	Text	Option	Option	Text	Option	Option	Option	Option	Number	Option
36	NS10026	pqai	pqai22	Option	No	0	0
37	NS10026	pqai	pqai23	Option	No	0	0
38	NS10026	pqai	pqai24	Option	No	0	0
39	NS10026	pqai	pqai25	Option	No	0	0
40	NS10026	pqai	pqai26	Option	Yes	1	1
41	NS10026	pqai	pqai27	Option	No	0	0
42	NS10026	pqai	pqai28	Option	Yes	1	1
43	NS10026	pqai	pqai29	Option	Yes	1	1
44	NS10026	pqai	pqai30	Option	Yes	1	1
45	NS10026	pqai	pqai31	Option	Yes	1	1
46	NS10026	pqai	pqai32	Option	No	0	0
47	NS10026	pqai	pqai33	Option	Yes	1	1
48	NS10026	pqai	pqai34	Option	Yes	1	1
49	NS10026	pqai	pqai35	Option	No	0	0
50	NS10026	rcfc	Rey Complex Figure [Copy]	Measure_Intro	Continue	0	0
51	NS10026	langhandcg	Language and Handedness (Caregiver)	Measure_Intro	Continue	0	0
52	NS10026	langhandcg	langhandcg00	List	Xhosa , English	2	2
53	NS10026	langhandcg	langhandcg00a	Option	No	0	0
54	NS10026	langhandcg	langhandcg01	Option	Xhosa	1	1
55	NS10026	langhandcg	langhandcg02	Option	English	2	2
56	NS10026	langhandcg	langhandcg03	Option	Xhosa	1	1
57	NS10026	langhandcg	langhandcg04	Option	Xhosa	1	1
58	NS10026	langhandcg	langhandcg05	Option	English	2	2
59	NS10026	langhandcg	langhandcg06	Option	English	2	2
60	NS10026	rcfc	rcf_structure01	Item_Instruction	Continue	0	0
61	NS10026	rcfc	rcfinst02	Item_Instruction	Continue	0	0
62	NS10026	langhandcg	langhandcg07	Text	xhosa		xhosayoyouyuoyoy
63	NS10026	langhandcg	langhandcg08	Option	English	0	0
64	NS10026	langhandcg	langhandcg09	Option	No	0	0
65	NS10026	langhandcg	langhandcg09a	Text	Xhosa questions are longer than english	0	0
66	NS10026	langhandcg	langhandcg10	Option	Right Hand	1	1
67	NS10026	langhandcg	langhandcg11	Option	Right Hand	1	1
68	NS10026	langhandcg	langhandcg12	Option	Right Hand	1	1
69	NS10026	langhandcg	langhandcg13	Option	Right Hand	1	1
70	NS10026	langhandcg	langhandcg14	Number	4	0	0
71	NS10026	langhandcg	langhandcg15	Option	RIGHT HAND	1	1
72	NS10026	nscg	NeuroScreen (Caregiver)	Measure_Intro	Continue	0	0
73	NS10026	nscg	nscg01	Measure_Instruction	Continue	0	0
74	NS10026	nscg	nscg02	Measure_Instruction	Continue	0	0
75	NS10026	nscg	nscg03	Measure_Instruction	Continue	0	0
76	NS10026	rcfc	reycopypic01	Photo	0		[object Object]
77	NS10026	techcg	Technology Use Questionnaire (Caregiver)	Measure_Intro	Continue	0	0
78	NS10026	techcg	techcg01	Option	No	0	0
79	NS10026	techcg	techcg02	Option	Very uncomfortable	0	0
80	NS10026	techcg	techcg03	Option	No	0	0
81	NS10026	techcg	techcg04	Option	Uncomfortable	1	1
82	NS10026	techcg	techcg05	Option	No	0	0
83
84	NS10026	rcfc	reyinst4	Measure_Instruction	Continue	0	0
85	NS10026	techcg	techcg07	List	Refuse	999	999
86	NS10026	techcg	techcg06	Option	Very difficult	5	5
87	NS10026	techcg	techcg08	List	None	1	1
88	NS10026	techcg	techcg02inst	Item_Instruction	Continue	0	0
89	NS10026	techcg	techcg09	Text	everything was difficult because i am not used on these smart phones of today.	0	0
90	NS10026	rcfi	Rey Complex Figure [Immediate]	Measure_Intro	Continue	0	0
91	NS10026	techcg	techcg10	Text	It seems better than writting on the papers	0	0
92	NS10026	rcfi	reyrecall_instruction01	Item_Instruction	Continue	0	0
93	NS10026	techcg	techcg11	Text	I would feel much better	0	0
94	NS10026	techcg	techcg12	Text	I wish everything can be done on these tablets.	0	0
95	NS10026	medcg	Caregiver Medical History	Measure_Intro	Continue	0	0
96	NS10026	medcg	medcg01	Option	No	0	0
97	NS10026	medcg	medcg02	Option	No	0	0
98	NS10026	medcg	medcg03	Option	No	0	0
99	NS10026	medcg	medcg04	Option	No	0	0
100	NS10026	medcg	medcg05	Option	No	0	0