How to group and display employee names - dynamic list

Good afternoon,

Can you please help in following,
I have a list of employees (exported from other software) with names, department and few other details (as shown in worksheet "Data")
I would like to display it as shown in worksheet "Display" - basically want to group the employee names and other details based on Dept.
Number of employee varies from dept to dept.

Regards
Nitin Asalkar

Employee Name Designation Function
Abhay Tapkir Associate General Manager Manufacturing
Abhijeet Kulkarni Associate General Manager Manufacturing
Ajit Rairikar Associate General Manager Manufacturing
Amit Mane Associate Manager Manufacturing
Amol Deo Associate Manager Manufacturing
Amol Choudhary Associate Manager Manufacturing
Amol Sherki Associate Manager Manufacturing
Anand Biradar Associate Manager Manufacturing
Anand Moholkar Associate Manager Manufacturing
Anand Bhosale Associate Manager Manufacturing
Anant Ghule Associate Manager Manufacturing
Anil Sawant Associate Manager Manufacturing
Anil Chapalgaonkar Associate Manager Manufacturing
Anup Ghanwat Associate Manager Manufacturing
Aravind Dhamale Associate Manager Manufacturing
Arun Neela Associate Manager Manufacturing
Arun Dhumal Associate Manager Manufacturing


COMMON IT
Chandrakant Shinde Deputy Manager Ashok Patil Associate Manager
Dattatraya Shelke Deputy Manager Eshwarappa Mande Diploma Trainee Engineer
Deepti Hadavale Deputy Manager Manufacturing
Dnyaneshwar Shejwal Diploma Trainee Engineer Abhay Tapkir Associate General Manager
Ganesh Devade Diploma Trainee Engineer Abhijeet Kulkarni Associate General Manager
CTT Ajit Rairikar Associate General Manager
Amol Patil Associate Manager Amit Mane Associate Manager
Dhananjay Garatkar Diploma Trainee Engineer Amol Deo Associate Manager
Finance Amol Choudhary Associate Manager
Amit Pansare Associate Manager Amol Sherki Associate Manager
Arun Pawar Associate Manager Anand Biradar Associate Manager
Gulab Dattatray Diploma Trainee Engineer Anand Moholkar Associate Manager
HR & Admin Anand Bhosale Associate Manager
Amar Gaikwad Associate Manager Anant Ghule Associate Manager
Amol Nevrekar Associate Manager Anil Sawant Associate Manager