Transpose rows into columns in BigQuery

	A	B	C	D	G	H	I	J	K	L	M	N	O	P	Q
1	search_term	entity	entitydetail	enittyCount	search_term	entity1	entitydetail1	entity2	entitydetail2	entity3	entitydetail3	entity4	entitydetail4	entityX	entitydetailX
2	van rental london	Rental	rental	3	van rental london	Rental	rental	Location	london	Car Type	van	Null	Null	Null	Null
3	van rental london	Location	london	3	van hire sheffield	Location	sheffield	Car Type	van	Hire	hire	Null	Null	Null	Null
4	van rental london	Car Type	van	3	van hire	Car Type	van	Hire	hire	Null	Null	Null	Null	Null	Null
5	van hire sheffield	Location	sheffield	3	san diego car rental	Rental	rental	Location	San Diego	Vehicle Type	car	Null	Null	Null	Null
6	van hire sheffield	Car Type	van	3	long term car rental london	Vehicle Type	car	Location	london	Rental	rental	Long Term	Long Term	Null	Null
7	van hire sheffield	Hire	hire	3	london car hire	Location	Location	Vehicle Type	car	Hire	hire	Null	Null	Null	Null
8	van hire	Car Type	van	2
9	van hire	Hire	hire	2
10	san diego car rental	Rental	rental	3
11	san diego car rental	Location	San Diego	3
12	san diego car rental	Vehicle Type	car	3
13	long term car rental london	Vehicle Type	car	4
14	long term car rental london	Location	london	4
15	long term car rental london	Rental	rental	4
16	long term car rental london	Long Term	Long Term	4
17	london car hire	Location	london	3
18	london car hire	Vehicle Type	car	3
19	london car hire	Hire	hire	3
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100