Vintage Analysis

[Anonymous]

Hi All,

Please find attached data

I have Table1 like this and need to arrange like Table 2.Can somebody let me know what is the workaround i.e using in set analysis to get output like Table 2

Table 1 :

Row Labels	Sum of Aug 2016	Sum of Sep 2016	Sum of Oct 2016	Sum of Nov 2016	Sum of Dec 2016	Sum of Jan 2017	Sum of Feb 2017
Jul 2016	3	9	35	1494	2767	2032	1510
Aug 2016		2	12	1194	2547	2001	1469
Sep 2016			9	784	1849	1712	1258
Oct 2016				392	1949	1990	1460
Nov 2016					173	496	266
Dec 2016						2	12
Jan 2017							22
Feb 2017
Mar 2017

Row Labels	MOB1	MOB2	MOB3	MOB4	MOB5	MOB6	MOB7	MOB8
Jul 2016	3	9	35	1,494	2,767	2,032	1,510	1,185
Aug 2016	2	12	1,194	2,547	2,001	1,469	1,102	1,274
Sep 2016	9	784	1,849	1,712	1,258	924	1,008	938
Oct 2016	392	1,949	1,990	1,460	1,060	1,099	1,032	1,043
Nov 2016	173	496	266	203	191	205	195	155
Dec 2016	2	12	6	16	20	11	20	32
Jan 2017	22	66	130	165	154	117	128	-
Feb 2017	37	80	79	90	83	105	-	-
Mar 2017	21	60	69	91	102	-	-	-