This One Step Ruins Your Queries.xlsx

	A	B	C	E	F	G	I	J	K
1	Source Data			End Query			New data to refresh the query
2	Product ID	Product	Unit Cost	Product ID	Product	Unit Cost	Product ID	Product	Unit Cost
3	PID36617	Hardware - Laptop	800	PID36617	Hardware - Laptop	800	PID36646	Hardware - AV Equipment	1500
4	PID36618	Hardware - Laptop	800	PID36618	Hardware - Laptop	800	PID36659	Hardware - AV Equipment	3000
5	PID36619	Hardware - Laptop	800	PID36619	Hardware - Laptop	800	PID36674	Hardware - AV Equipment	1000
6	PID36621	Software - O365	1500	PID36637	Hardware - Desktop	700	PID36676	Hardware - AV Equipment	3000
7	PID36622	Software - O365	1500	PID36642	Hardware - Laptop	800
8	PID36623	Software - O365	1500	PID36644	Hardware - Laptop	650
9	PID36624	Software - O365	1500	PID36645	Hardware - Laptop	650
10	PID36625	Software - O365	1500	PID36677	Hardware - Desktop	650
11	PID36626	Software - O365	4800	PID36682	Hardware - Desktop	300
12	PID36627	Software - O365	7500
13	PID36628	Software - O365	1500
14	PID36629	Software - O365	1500
15	PID36630	Software - O365	1500
16	PID36635	License - Antivirus	100
17	PID36636	License - Antivirus	150
18	PID36637	Hardware - Desktop	700
19	PID36638	Software - O365	4800
20	PID36639	Software - O365	1500
21	PID36640	License - Antivirus	500
22	PID36641	Software - O365	4800
23	PID36642	Hardware - Laptop	800
24	PID36643	License - Antivirus	500
25	PID36644	Hardware - Laptop	650
26	PID36645	Hardware - Laptop	650
27	PID36677	Hardware - Desktop	650
28	PID36680	License - Antivirus	300
29	PID36681	License - Antivirus	500
30	PID36682	Hardware - Desktop	300
31	PID36683	Software - O365	6000
32	PID36684	Software - O365	4800
33	PID36685	License - Antivirus	100
34	PID36686	Software - O365	1200
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