# How to combine the same department name?

**URL:** <https://community.glideapps.com/t/how-to-combine-the-same-department-name/54819>\
**Category:** Ask for Help\
**Created:** [November 24, 2022, 2:33am UTC](https://community.glideapps.com/t/how-to-combine-the-same-department-name/54819 "2022-11-24T02:33:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![agungmrf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agungmrf/32/50700_2.png) [@agungmrf](https://community.glideapps.com/u/agungmrf)\
**Post date:** [November 24, 2022, 2:33am UTC](https://community.glideapps.com/t/how-to-combine-the-same-department-name/54819/1 "2022-11-24T02:33:57Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/028d39a37425b319e9f9a111f0621749a386f8e7.png)

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:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8e3ef679d58484c2eafaa37a1713947a1cf1312.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46e33a797af613530b949cbc93e318e43473cf5f.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 24, 2022, 2:40am UTC](https://community.glideapps.com/t/how-to-combine-the-same-department-name/54819/2 "2022-11-24T02:40:43Z")

</div>

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.