How to see changes over period based on one criteria (and amount with it)

[okvals48]

Hi,
I have a report, in which I would like to see if risk stage has changed over a certain period, usually I only observe the first period and last (first period is beginning of the year and last is current month for report )
Basically I am observing the movements between stages1 to 2 to 3 and backwards ( for example customer can be in stage 1 and jump to stage 3, and then be upgraded to stage 2). If there is a change in risk stage or there is non, I need to report movements , regarding the balance I also need to report movements between stages, and also total difference between periods.

Changes are primarily observed on GCOA level but I also look the movements on customer id.

My biggest problem is that I can not resolve how to see changes between risk stages, when data are sorted like they are in my table ( periods are in one column and risk stages are in separate column).

I am using Excel 2016 ( work place excel)

Thanks in advance for your help

CoA	CoA Name	Customer_id	Customer name	Debit	Credit	Balance	CoA_ID	CoAwCoA_ID	RiskStage	COA Gross carrying amount	COA Credit loss allowance	GCOA	Period
37101	xyz	198	X	900	0	900	3	037101-3	1	122111301		122111301	1
37191	ccc	198	X	0	9	-9	3	037191-3	1		122111351	122111351	1
37101	xyz	198	X	800	0	800	4	037101-4	2	122111301		122211301	2
37191	ccc	198	X	0	9	-10	4	037191-4	2		122111351	122211351	2
37101	xyz	198	X	1000	0	1000	3	037101-3	1	122111301		122111301	3
37191	ccc	198	X	0	9	-11	3	037191-3	1		122111351	122111351	3
37101	xyz	198	X	500	0	500	3	037101-3	3	122111301		122311301	4
37191	ccc	198	X	0	9	-15	3	037191-3	3		122111351	122311351	4