Book1 (1).xlsx

	A	B	C	E	F	G	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	TABLE 1			TABLE 2			TABLE 3 - Desired Output
2	Product	Location	Qty_Available	Account	UPC	Qty_Needed	Location Qty	UPC	Location	Customer 1	Customer 2	Customer 3	Customer 4	Customer 5	Customer 6	Customer 7	Customer 8	Customer 9	Customer 10	Customer 11	Customer 12	Customer 13	Customer 14	Customer 15	Customer 16
3	Apple	B1	1.960	Customer 1	Apple	500	0	Apple	B1	500	499	89	872	-	-	-	-	-	-	-	-	-	-	-	-
4	Apple	B2	1.960	Customer 2	Apple	499	0	Apple	B2	-	-	-	28	1.599	333	-	-	-	-	-	-	-	-	-	-
5	Apple	B3	1.960	Customer 3	Apple	89	0	Apple	B3	-	-	-	-	-	866	1.094	-	-	-	-	-	-	-	-	-
6	Apple	B4	1.960	Customer 4	Apple	900	0	Apple	B4	-	-	-	-	-	-	1.960	-	-	-	-	-	-	-	-	-
7	Apple	B5	1.960	Customer 5	Apple	1.599	0	Apple	B5	-	-	-	-	-	-	1.945	15	-	-	-	-	-	-	-	-
8	Apple	B6	1.655	Customer 6	Apple	1.199	0	Apple	B6	-	-	-	-	-	-	-	43	24	1.588	-	-	-	-	-	-
9	Apple	B7	1.960	Customer 7	Apple	4.999	0	Apple	B7	-	-	-	-	-	-	-	-	-	1.960	-	-	-	-	-	-
10	Apple	B8	1.960	Customer 8	Apple	58	0	Apple	B8	-	-	-	-	-	-	-	-	-	1.960	-	-	-	-	-	-
11	Apple	B9	1.960	Customer 9	Apple	24	0	Apple	B9	-	-	-	-	-	-	-	-	-	1.960	-	-	-	-	-	-
12	Apple	B10	1.960	Customer 10	Apple	9.623	0	Apple	B10	-	-	-	-	-	-	-	-	-	1.960	-	-	-	-	-	-
13	Apple	B11	1.960	Customer 11	Apple	2.727	0	Apple	B11	-	-	-	-	-	-	-	-	-	195	1.765	-	-	-	-	-
14	Apple	B12	1.960	Customer 12	Apple	999	0	Apple	B12	-	-	-	-	-	-	-	-	-	-	962	998	-	-	-	-
15	Apple	B13	1.960	Customer 13	Apple	3.919	0	Apple	B13	-	-	-	-	-	-	-	-	-	-	-	1	1.959	-	-	-
16	Apple	B14	1.960	Customer 14	Banana	5.000	0	Apple	B14	-	-	-	-	-	-	-	-	-	-	-	-	1.960	-	-	-
17	Banana	B1	2.000	Customer 15	Banana	9.000	0	Banana	B1	-	-	-	-	-	-	-	-	-	-	-	-	-	2.000	-	-
18	Banana	B2	2.500	Customer 16	Banana	1.000	0	Banana	B2	-	-	-	-	-	-	-	-	-	-	-	-	-	2.500	-	-
19	Banana	B3	3.000				0	Banana	B3	-	-	-	-	-	-	-	-	-	-	-	-	-	500	2.500	-
20	Banana	B4	3.500				0	Banana	B4	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3.500	-
21	Banana	B5	4.000				0	Banana	B5	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3.000	1.000
22
23			42.135			42.135			42.135	500	499	89	900	1.599	1.199	4.999	58	24	9.623	2.727	999	3.919	5.000	9.000	1.000
24
25
26
27
28
29							TABLE 3 - Desired Output
30							Location Qty	UPC	Location	Customer 1	Customer 2	Customer 3	Customer 4	Customer 5	Customer 6	Customer 7	Customer 8	Customer 9	Customer 10	Customer 11	Customer 12	Customer 13
31								Apple	B1	500	499	89	872
32								Apple	B2				28	1.599	333
33								Apple	B3						866	1094
34								Apple	B4							1.960
35								Apple	B5							1.945	15
36								Apple	B6								43	24	1588
37								Apple	B7										1.960
38								Apple	B8										1.960
39								Apple	B9										1.960
40								Apple	B10										1.960
41								Apple	B11										195	1765
42								Apple	B12											962	998
43								Apple	B13												1	1.959
44								Apple	B14													1.960
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