Merge Data.xlsx

	A	B	C	D	E	F	H	I	K	L
1
2
3
4	Date	Item	Sales Rep	Quantity	Price	Commission	Item	Product Id	Sales Rep	Region
5	7/1/2018	Printer	Laura	10	80	8%	Printer	KL001	Laura	US
6	7/1/2018	White Board	Stacey	18	40	6%	White Board	KL002	Stacey	Canada
7	7/1/2018	Office Chair	Mark	7	230	8%	Office Chair	KL003	Mark	US
8	7/1/2018	White Board	Stacey	15	40	3%	Diary	KL004	Bob	Europe
9	7/1/2018	Diary	Laura	6	16	1%	Projector	KL005	John	Asia
10	7/1/2018	Projector	Stacey	9	150	2%
11	7/1/2018	Diary	Bob	15	16	1%
12	7/1/2018	Printer	Bob	22	80	11%
13	7/1/2018	Projector	Mark	13	150	2%
14	7/1/2018	White Board	Stacey	18	40	6%
15	7/1/2018	Office Chair	Mark	7	230	8%
16	7/1/2018	White Board	Stacey	15	40	3%
17	7/1/2018	Diary	Laura	6	16	1%
18	7/1/2018	Projector	Stacey	9	150	2%
19	7/1/2018	Diary	Bob	15	16	1%
20	7/1/2018	Printer	Bob	22	80	11%
21	7/1/2018	Projector	Mark	13	150	2%
22	7/2/2018	Diary	Laura	12	16	3%
23	7/2/2018	White Board	Stacey	4	40	5%
24	7/2/2018	Office Chair	Mark	19	230	11%
25	7/2/2018	White Board	Mark	4	40	6%
26	7/2/2018	Diary	Laura	6	16	7%
27	7/2/2018	Office Chair	Laura	15	230	11%
28	7/2/2018	Printer	Laura	16	80	4%
29	7/2/2018	White Board	John	7	40	10%
30	7/2/2018	White Board	Laura	11	40	5%
31	7/2/2018	Printer	Bob	9	80	6%
32	7/2/2018	Printer	Mark	21	80	4%
33	7/2/2018	White Board	Laura	2	40	3%
34	7/2/2018	Diary	Laura	12	16	3%
35	7/2/2018	White Board	Stacey	4	40	5%
36	7/2/2018	Office Chair	Mark	19	230	11%
37	7/2/2018	White Board	Mark	4	40	6%
38	7/2/2018	Diary	Laura	6	16	7%
39	7/2/2018	Office Chair	Laura	15	230	11%
40	7/2/2018	Printer	Laura	16	80	4%
41	7/2/2018	White Board	John	7	40	10%
42	7/2/2018	White Board	Laura	11	40	5%
43	7/2/2018	Printer	Bob	9	80	6%
44	7/2/2018	Printer	Mark	21	80	4%
45	7/2/2018	White Board	Laura	2	40	3%
46	7/3/2018	Diary	Laura	17	16	5%
47	7/3/2018	White Board	John	18	40	6%
48	7/3/2018	White Board	John	9	40	1%
49	7/3/2018	White Board	Mark	7	40	1%
50	7/3/2018	Office Chair	Laura	12	230	6%
51	7/3/2018	Diary	Mark	22	16	4%
52	7/3/2018	Diary	Laura	17	16	5%
53	7/3/2018	White Board	John	18	40	6%
54	7/3/2018	White Board	John	9	40	1%
55	7/3/2018	White Board	Mark	7	40	1%
56	7/3/2018	Office Chair	Laura	12	230	6%
57	7/3/2018	Diary	Mark	22	16	4%
58	7/4/2018	Projector	John	5	150	11%
59	7/4/2018	Printer	Mark	14	80	11%
60	7/4/2018	Diary	Laura	8	16	3%
61	7/4/2018	Office Chair	Laura	6	230	5%
62	7/4/2018	Diary	Stacey	7	16	8%
63	7/4/2018	Printer	Mark	16	80	4%
64	7/4/2018	Projector	John	17	150	12%
65	7/4/2018	Diary	Mark	7	16	8%
66	7/4/2018	Projector	John	5	150	11%
67	7/4/2018	Printer	Mark	14	80	11%
68	7/4/2018	Diary	Laura	8	16	3%
69	7/4/2018	Office Chair	Laura	6	230	5%
70	7/4/2018	Diary	Stacey	7	16	8%
71	7/4/2018	Printer	Mark	16	80	4%
72	7/4/2018	Projector	John	17	150	12%
73	7/4/2018	Diary	Mark	7	16	8%
74	7/5/2018	Diary	John	21	16	9%
75	7/5/2018	Diary	Laura	23	16	11%
76	7/5/2018	Projector	Laura	2	150	2%
77	7/5/2018	Projector	John	22	150	7%
78	7/5/2018	White Board	Stacey	22	40	1%
79	7/5/2018	Printer	Mark	10	80	11%
80	7/5/2018	Printer	Bob	13	80	5%
81	7/5/2018	Office Chair	Stacey	11	230	12%
82	7/5/2018	Office Chair	John	9	230	7%
83	7/5/2018	Office Chair	Stacey	16	230	11%
84	7/5/2018	Office Chair	Stacey	18	230	1%
85	7/5/2018	Diary	Mark	15	16	2%
86	7/5/2018	White Board	Bob	18	40	6%
87	7/5/2018	White Board	Stacey	18	40	4%
88	7/5/2018	Diary	Stacey	22	16	3%
89	7/5/2018	Diary	Laura	12	16	11%
90	7/6/2018	Printer	John	20	80	1%
91	7/6/2018	Office Chair	Laura	10	230	2%
92	7/6/2018	Office Chair	Mark	9	230	3%
93	7/6/2018	Printer	Mark	17	80	3%
94	7/6/2018	White Board	Bob	4	40	9%
95	7/6/2018	Projector	Mark	16	150	3%
96	7/6/2018	Printer	Laura	8	80	2%
97	7/6/2018	White Board	Stacey	23	40	6%
98	7/7/2018	Projector	Stacey	20	150	10%
99	7/7/2018	Office Chair	Bob	22	230	10%
100	7/7/2018	Office Chair	Mark	6	230	10%