Group level count update on new column

[alt_tush]

Hi,

I have below set of data with "n" number of fields

DEPT_ID	Name
HR	ABC
HR	XYZ
HR	PQR
IT	IT1
IT	IT2
ADMIN	Admin1
ADMIN	Admin2
ADMIN	Admin3
ADMIN	Admin4

My expected output should be, i want count of entries based on group level of DEPT_ID column

Expected output :-

ID	Name	Count
HR	ABC	3
HR	XYZ	3
HR	PQR	3
IT	IT1	2
IT	IT2	2
ADMIN	Admin1	4
ADMIN	Admin2	4
ADMIN	Admin3	4
ADMIN	Admin4	4

Appreciate your help :)

Thank you

[binu_acs]

@alt_tush One way of doing

[nagakavyasri]

Another way: