dummy2

	A	B	C	D	E	F	G	H	I	J	K
1	Trans	Time	Quantity	Discount	Price	RESULT --->	Trans	Time	Quantity	Discount	Price
2	item1	06/08/2023 19:36:02	2	$0.50	$1.49		item1	06/08/2023 19:36:02	2	0.5	1.49
3	item2	07/08/2023 09:49:04	1	$0.00	$1.99		item2	07/08/2023 9:49:04	1	0	1.99
4	item3	07/08/2023 10:09:47	1	$0.00	$1.99		item3	07/08/2023 10:09:47	2	0.5	3.48
5	item3	07/08/2023 10:09:47	1	$0.50	$1.49			07/08/2023 10:09:47	1	0.5	1.49
6	item4	07/08/2023 12:56:03	1	$0.00	$1.99		item4	07/08/2023 12:56:03	1	0	1.99
7	item5	07/08/2023 13:46:34	1	$0.00	$1.99		item5	07/08/2023 13:46:34	1	0	1.99
8	item6	07/08/2023 18:15:37	1	$0.00	$1.99		item6	07/08/2023 18:15:37	2	0.5	3.48
9	item6	07/08/2023 18:15:37	1	$0.50	$1.49			07/08/2023 18:15:37	2	0.5	3.48
10	item6	07/08/2023 18:15:37	1	$0.00	$1.99			07/08/2023 18:15:37	2	0.5	3.48
11	item6	07/08/2023 18:15:37	1	$0.50	$1.49			07/08/2023 18:15:37	1	0.5	1.49
12
13		EXPECTED
14	Trans	Time	Quantity	Discount	Price
15	item1	06/08/2023 19:36:02	2	$0.50	$1.49
16	item2	07/08/2023 09:49:04	1	$0.00	$1.99
17	item3	07/08/2023 10:09:47	2	$0.50	$3.48
18	item4	07/08/2023 12:56:03	1	$0.00	$1.99
19	item5	07/08/2023 13:46:34	1	$0.00	$1.99
20	item6	07/08/2023 18:15:37	4	$1.00	$6.96
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