Combine Data into one Table.xlsx

	A	B	C	D	G	H	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	Period	Outstanding	Aging	Overdue Category	Aging Code	Overdue category
2	3-Mar-21	1723	5	150 days	1	30 days
3	3-Aug-21	1012	1	30 days	2	60 days	Sum of Outstanding		Period - Year	Period - Quarter	Period - Month
4	22-Jul-21	1842	1	30 days	3	90 days			2020						2021									2022	Grand Total
5	11-Apr-21	1055	6	180 days	4	120 days			Q2	Q3			Q4		Q1		Q2		Q3			Q4		Q1
6	22-Jun-20	1405	2	60 days	5	150 days	Aging	Overdue Category	Jun	Jul	Aug	Sep	Nov	Dec	Jan	Mar	Apr	Jun	Jul	Aug	Sep	Oct	Dec	Jan
7	15-Sep-20	1523	1	30 days	6	180 days	1	30 days		1911		1523		1039					1842	1012					7327
8	12-Oct-21	1306	3	90 days			2	60 days	1405										1396		1693	1036			5530
9	24-Jan-22	1770	6	180 days			3	90 days			1630				1090							1306	1536		5562
10	3-Sep-20	1967	4	120 days			4	120 days				1967	1098	1464	1689						2942				9160
11	27-Nov-20	1098	4	120 days			5	150 days			1869					1723					1339			1211	6142
12	26-Sep-21	1693	2	60 days			6	180 days						3258			1055	1984						1770	8067
13	7-Jul-21	1396	2	60 days			Grand Total		1405	1911	3499	3490	1098	5761	2779	1723	1055	1984	3238	1012	5974	2342	1536	2981	41788
14	5-Dec-20	1507	6	180 days
15	28-Jan-21	1090	3	90 days				NPL 30 Up	100.00%	0.00%	100.00%	56.36%
16	15-Oct-21	1036	2	60 days				NPL 60 Up	0.00%	0.00%	100.00%	56.36%
17	24-Jan-22	1211	5	150 days				NPL 90 Up	0.00%	0.00%	53.42%	56.36%
18	16-Jul-20	1911	1	30 days
19	12-Dec-20	1751	6	180 days
20	1-Jan-21	1689	4	120 days
21	12-Aug-20	1869	5	150 days
22	2-Dec-20	1039	1	30 days
23	20-Sep-21	1011	4	120 days
24	15-Sep-21	1931	4	120 days
25	30-Dec-20	1464	4	120 days
26	7-Jun-21	1984	6	180 days
27	18-Aug-20	1630	3	90 days
28	15-Dec-21	1536	3	90 days
29	19-Sep-21	1339	5	150 days
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