I believe you need data from sheet 1 to sheet2 and I already given you that solution.. and I did not found any "Department" there.. can you check?

Also, if you need some other help - update the workbook accordingly and show me your expected results. Thanks.


Regards,
DILIPandey
<click on below * if this helps>