Book1.xlsx

	A	B	C	E	F	G	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
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
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	1094
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	1588
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 1	Apple	9,623	0	Apple	B10										1,960
13	Apple	B11	1,960	Customer 2	Apple	2,727	0	Apple	B11										195	1765
14	Apple	B12	1,960	Customer 3	Apple	999	0	Apple	B12											962	998
15	Apple	B13	1,960	Customer 4	Apple	3,919	0	Apple	B13												1	1,959
16	Apple	B14	1,960				0	Apple	B14													1,960
17
18
19
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