How to combine the same department name?

Hello everyone, I want to display the first image, if the department name already exists, only 1 is displayed, not duplicated like the image above, but the data file is still there and not deleted. Anyone know the solution to this problem?

Here are the results of my data that I use:

Best option is to create a new table with all possible departments. Then create a multiple relation from the departments table to the “division” table.

1 Like