progressing on my Xlookup project

with the support of some members of this community I managed to create the sheet I wanted, it manages the training of my team, and it displays a summary of each employee when the name and last name is entered. with a Xlookup and transpose functions.

now I will like to remove he operations that an employee has no data.  so when I enter the employee name and last name it will display his role and only the role that the employee has any training level. for example for employee name3 lastname3 it will only show  "inspection:  1" without the other operations showing an empty field.

I managed to make add a filter but it needs to be refreshed after every entry to show the data of employee. I find out a macro that will auto refresh.  do anyone has any experience with a XLOOKUP skips empty cells.