Rows to column

[akumar2609]

Hi All,

Need help in getting the below problem solve. I have below table where Previous day and Current day data are available. Now, my requirement is to know the daily movement on intercompany level. Please note that all the inter company will not be available everyday. 

Input data

IC	Profit Centre	Currency	Hedge Trax	Sales	Data
2509	1111	USD	No	1000	8/19/2023
7501	2222	USD	Yes	2000	8/19/2023
7890	3333	USD	Yes	3000	8/19/2023
8712	4444	USD	Yes	400	8/19/2023
7501	2222	USD	No	500	8/20/2023
7890	3333	USD	Yes	650	8/20/2023
8712	4444	USD	No	500	8/20/2023
6767	5555	EUR	Yes	550	8/20/2023

My Required Output :-

IC	Profit Centre	Currency	Hedge Trax	Sales	Data	IC	Profit Centre	Currency	Hedge Trax	Sales	Data	Daily Movement
2509	1111	USD	No	1000	8/19/2023							1000
7501	2222	USD	Yes	2000	8/19/2023	7501	2222	USD	No	500	8/20/2023	1500
7890	3333	USD	Yes	3000	8/19/2023	7890	3333	USD	Yes	650	8/20/2023	2350
8712	4444	USD	Yes	400	8/19/2023	8712	4444	USD	No	500	8/20/2023	-100
						6767	5555	EUR	Yes	550	8/20/2023	-550

Thank you in advance.

[FinnCharlton]

@akumar2609 , the second workflow will work as intended, misunderstood your logic slightly while making the first