# Grouping items

**URL:** <https://community.glideapps.com/t/grouping-items/2557>\
**Category:** Ask for Help\
**Created:** [December 1, 2019, 2:20pm UTC](https://community.glideapps.com/t/grouping-items/2557 "2019-12-01T14:20:11Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![ledafyomi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ledafyomi/32/1932_2.png) [@ledafyomi](https://community.glideapps.com/u/ledafyomi)\
**Post date:** [December 1, 2019, 2:20pm UTC](https://community.glideapps.com/t/grouping-items/2557/1 "2019-12-01T14:20:11Z")

</div>

Hi,  
I have a sheet with column A, B and C.  
In column A, I have 2 types of cells : Category 1 and Category 2.  
In colum B and C I have other types of informations.  
I have approx. 100 rows.  
I would like to “group” on glide app the list in “Category 1” or “Category 2” and not having the whole list on the approx. rows.  
How can I do this ?  
Warmly

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [December 1, 2019, 3:29pm UTC](https://community.glideapps.com/t/grouping-items/2557/2 "2019-12-01T15:29:15Z")

</div>

All you need to do is go to the Tabs section, create a new Tab by selecting the Plus sign in the upper right. Name it Category 1 and point it to your sheet. Then select the Layout section, click on that new tab and go to Features/Filter. Your filter will be “is” “Category 1”. That’s it. You can do the same for Cat 2, or just add a filter the the default Tab for that sheet.

---

<div class="post-metadata">

**Author:** ![ledafyomi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ledafyomi/32/1932_2.png) [@ledafyomi](https://community.glideapps.com/u/ledafyomi)\
**Post date:** [December 1, 2019, 7:22pm UTC](https://community.glideapps.com/t/grouping-items/2557/3 "2019-12-01T19:22:56Z")

</div>

Thank you for getting back to me.  
I am sorry but it doesn’t make what I need.  
I repeat in other words:  
On my google sheet, I have a single sheet named “Test”.  
In this sheet I have approx. 100 rows in 3 columns : A, B, C.  
In column A, I have differents celles named either Category 1 or Category 2.  
On glide now:  
How do I show for Tab “Test” not a list of 100 items but a list of 2 items named Category 1 or Category 2. And then upon clicking on Category 1 or Category 2 I see the related items classified?

---

<div class="post-metadata">

**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\
**Post date:** [December 1, 2019, 10:37pm UTC](https://community.glideapps.com/t/grouping-items/2557/4 "2019-12-01T22:37:50Z")

</div>

So, it’s a basic inline list…

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [December 2, 2019, 3:56am UTC](https://community.glideapps.com/t/grouping-items/2557/5 "2019-12-02T03:56:22Z")

</div>

@ledafyomi Here you go. Make a copy of it and explore. [https://n6krp.glideapp.io/](https://n6krp.glideapp.io/)

---

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [December 2, 2019, 2:22pm UTC](https://community.glideapps.com/t/grouping-items/2557/6 "2019-12-02T14:22:09Z")

</div>

Hey @ledafyomi sounds like you’re needing multiple relations - have you watched these tutorials? [https://docs.glideapps.com/all/reference/data-editor/relation-column](https://docs.glideapps.com/all/reference/data-editor/relation-column)

---

<div class="post-metadata">

**Author:** ![ledafyomi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ledafyomi/32/1932_2.png) [@ledafyomi](https://community.glideapps.com/u/ledafyomi)\
**Post date:** [December 3, 2019, 4:39pm UTC](https://community.glideapps.com/t/grouping-items/2557/7 "2019-12-03T16:39:41Z")

</div>

Thank you so much for your kind help.  
It helped me a lot and it work now !  
Warmly

---

<div class="post-metadata">

**Author:** ![ledafyomi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ledafyomi/32/1932_2.png) [@ledafyomi](https://community.glideapps.com/u/ledafyomi)\
**Post date:** [December 3, 2019, 4:48pm UTC](https://community.glideapps.com/t/grouping-items/2557/8 "2019-12-03T16:48:41Z")

</div>

@George

 ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0beb0ca6e84c87e2ef2e350ac799f7087b3a52e8.jpeg) \_B how did you achieve the creation of this column (in yellow) ?

---

<div class="post-metadata">

**Author:** ![Secura\_4x4](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/secura_4x4/32/1513_2.png) [@Secura\_4x4](https://community.glideapps.com/u/Secura_4x4)\
**Post date:** [December 3, 2019, 5:17pm UTC](https://community.glideapps.com/t/grouping-items/2557/9 "2019-12-03T17:17:34Z")

</div>

He added right there on the upper right corner

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [December 3, 2019, 5:37pm UTC](https://community.glideapps.com/t/grouping-items/2557/10 "2019-12-03T17:37:39Z")

</div>

Yes as @Secura_4x4 says. On that Data screen in the upper right is a + (plus sign). That is where you can add columns. I this case I added a Relations column.

---

<div class="post-metadata">

**Author:** ![ledafyomi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ledafyomi/32/1932_2.png) [@ledafyomi](https://community.glideapps.com/u/ledafyomi)\
**Post date:** [December 3, 2019, 10:35pm UTC](https://community.glideapps.com/t/grouping-items/2557/11 "2019-12-03T22:35:35Z")

</div>

OK got it.  
Thanks @George\_Band @Secura_4x4

---

<div class="post-metadata">

**Author:** ![ledafyomi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ledafyomi/32/1932_2.png) [@ledafyomi](https://community.glideapps.com/u/ledafyomi)\
**Post date:** [December 4, 2019, 5:12pm UTC](https://community.glideapps.com/t/grouping-items/2557/12 "2019-12-04T17:12:39Z")

</div>

Again @George_B :  
I added a component “Separator” in the layout of one tab (Home).  
Why does this component automatically added in the the layout of the other tab (Test) ?  
How to avoid this ?  
Warmly

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [December 4, 2019, 5:42pm UTC](https://community.glideapps.com/t/grouping-items/2557/13 "2019-12-04T17:42:42Z")

</div>

That would only happen if both tab’s were pointing to the same sheet. Otherwise it shouldn’t happen. It doesn’t happen in the test I just tried.

---

<div class="post-metadata">

**Author:** ![ledafyomi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ledafyomi/32/1932_2.png) [@ledafyomi](https://community.glideapps.com/u/ledafyomi)\
**Post date:** [December 5, 2019, 8:05am UTC](https://community.glideapps.com/t/grouping-items/2557/14 "2019-12-05T08:05:52Z")

</div>

OK thank you @George_B for your kind help.
