Headcount movement

[unnijoy]

I have a Headcount Table as below.

Month	Empid	DOJ	Manager
Dec-23	1	Mar-20	James
Dec-23	2	Jan-19	Tom
Dec-23	3	Dec-22	Alen
Dec-23	4	Sep-21	James
Dec-23	5	Jun-22	Alen
Dec-22	6	May-19	James
Jan-23	1	Mar-20	Tom
Jan-23	2	Jan-19	Tom
Jan-23	3	Dec-22	Alen
Jan-23	7	Sep-23	James
Jan-23	5	Jun-23	James
Jan-23	6	May-23	Tom
Jan-23	8	Jan-23	James
Jan-23	9	Jan-23	Tom

 Based on this table i need to create a table that show how many new Hire, Employe moved out and move In and attrited employees based on Manager. Below is the output that am looking for. Please help me to achive the below output.

Manager	Dec-22 HC	Transfer In	Transfer Out	Exit	New Hire	Jan-23 HC
James	3	1	2	1	2	3
Tom	1	2	0	0	1	4
Alen	2	0	1	0	0	1